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