Forum Discussion
Helper IVHow to start thinking in DAX?
Anonymous , Start with
https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics
You Tube : https://youtu.be/m1eLTtZHGs4
DAX Fridays have a few Check there channel
Measures vs Calculated Columns: https://www.youtube.com/watch?v=nJSXty9Y4tM
DAX Fridays! #5: CALCULATE (Part 1) : https://www.youtube.com/watch?v=-oDpOfhgmzA
For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finaleTo get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/Refer
https://community.powerbi.com/t5/Desktop/Dynamic-measure-calculation-for-hierarchy-data/td-p/592546
https://community.powerbi.com/t5/Desktop/How-to-create-column-and-row-hierarchies-in-tables/td-p/81168And one from my side - https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184
DAX Fridays! #8: CALCULATE (Part 2): https://www.youtube.com/watch?v=uZ15A13AsHY
The best DAX courses in the world are here:
www.sqlbi.com
This is a corner of the Internet that's been created by the two world-leading DAX Maestros: Marco Russo and Alberto Ferrari. They ARE the ultimate source of knowledge on DAX. I've taken almost all their courses and have read "The Definitve Guide to DAX" several times (and will still be reading).
This is where my knowledge comes from. And it's rock-solid.
Best
D