The latest DAX functions in Power BI can be very "power"ful! Patrick starts by looking at the INDEX function to solve a customer problem! Blog announcement: https://powerbi.microsoft.com/blog/power-bi-december-2022-feature-summary/#post-21693-_Toc121395731 INDEX function (DAX) https://learn.microsoft.com/dax/index-function-dax WINDOW function (DAX) https://learn.microsoft.com/dax/window-function-dax Chris Webb's Blog https://blog.crossjoin.co.uk/2023/01/02/why-dax-window-functions-are-important-for-performance-in-power-bi-directquery-mode/ Jeffrey Wang's Blogs on Window Function https://pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/ https://pbidax.wordpress.com/2022/12/23/introducing-dax-window-functions-part-2/

Struggling to get dates when using a between date slicer, or a before, or after? Patrick walks through a straightforward way to get the date values when using a date slicer in Power BI!

Dynamic titles in Power BI can be really useful. What about a multi-line title? Patrick is answering a commenter's question on how to create a two-line dynamic title! Dynamic Titles in Power BI Desktop https://www.youtube.com/watch?v=TYLKDPcvgK8

Every struggle with writing DAX and having to flip between the report view and the model view in Power BI Desktop? The struggle was real! Patrick shows you a new update that overcomes this!

Calculating Days since a given date in DAX is pretty straight forward. But, what if you want flexibility with different dates in your model? Patrick shows you how to do that with Power BI.

Struggling with understanding what is filtering your visual or Power BI report? Patrick walks you through how you can tell what is going on. SQLBI Filter Context: https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/