Forum Discussion

Helper IV

6 years ago

Solved

How to start thinking in DAX?

Hello, I'm not sure if I'm posting this in the right section but can somebody recommend a really good reading or youtube source for mastering DAX way of thinking. I've been working with Powe...

amitchandak
6 years ago
Anonymous , Start with

https://www.analyticsvidhya.com/blog/2019/05/10-useful-data-analysis-expressions-dax-functions-power-bi/

https://docs.microsoft.com/en-us/power-bi/desktop-quickstart-learn-dax-basics

You Tube : https://youtu.be/m1eLTtZHGs4

https://youtu.be/W0mG3KFR3Hw

https://youtu.be/3u7MQz1EyPY

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-finale

To 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/81168

And 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

Anonymous

Not applicable

6 years ago

PshemekFLK ,

I too am a starter in Power BI and have no experience in Excel. i think i started working onPower BI just 2 months before.

My secret sauce of DAX is

1. Know the functions.

2. Follow Videos on YouTube. There are lots of them. But follow only one channel for DAX formula.

3. Try solving real problem in the community.

These 3 things have helped me atleast think the DAX way. The community is awesome and the seasoned champions and Super Users provide a lot of insightful solutions.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!