CALCULATE Is The Key To Anything Advanced - (1.14) Ultimate Beginners Guide to DAX 2020

Follow along to the beginners guide DAX tutorials by using the demo data available for download. Enjoy!

Details of what you will learn during this course
Learn - what DAX is and why you need to learn it when using Power BI
Learn - the basics of DAX calculations
Understand - formula syntax, writing comments & variables
Review - how the data model and DAX calculations work together
Learn - what the most important concept of DAX is - CONTEXT
Understand - what the CALCULATE statement does
Learn - what table functions are and when to use them
Review - time intelligence functions
Understand - how important learning DAX well is when using Power BI

Here are the specifics for the course
Learn how to;
Use DAX formula with Power BI
When and where to use DAX functions
Utilise some of the great features built into the DAX formula bar
Use the data model in combination with DAX formula
Understand the concept of CONTEXT
Use the CALCULATE statement
Create filters using table functions
Incorporate time intelligence functions in your analysis
Become a DAX master by combining patterns of DAX formula

***** Learning Power BI? *****

[Don-ecvc]

Hi Sam, In some situations you can use SUMX(FILTER(<table>, <filter>), <expression>),
At the same time you can use CALCULATE(SUMX(<table>, <expression>), FILTER(<table>, <filter>))

Both will give the same output. When should you use which?

[hamzamottali]

thank you sam, i love your teach way, can you compare between tow months in the same year ?

[Tat-cxlr]

Merci pour ce partage. Remarque il y’a une erreur sur votre rapport Q1-2020 vs Q1-2019

[mohdmuzammil]

Can you please help to understand the error which shows in quarter matrix look in 2019 Q1 sales comparison with Q1 2020 it shows different values why so, same goes with Q4 kindly respond

[soflute]

Hi, Am having problem is seeing my Sales in NC on the visualization table with the Measures you used when I try the same thing i.e. Sales in "NC" = CALCULATE( [Total Sales], Locations[State Code] = "NC" ). No data is showing on my visual table for Sales in N"C" or F"L", why am I having this problem.