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/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— rel=”nofollow”>http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #GuyInACube