Main Difference Between DAX & Excel Formulas - (1.8) 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? *****

***** Related Links*****

***** Related Course Modules*****

***** Related Support Forum Posts*****

[EnterpriseDNA]

Learning Power BI?

Related

Related Course

Related Support Forum

[vanessaadade]

Your didactics is incredible! Thank you so much for sharing such an excellent guide.

[TittleVarghese]

I can see that in the Data Model view you haven't linked the Key Measures table to any other tables. Could you please elaborate on that?

[lmao]

Hello. Thanks for the video. I would like to ask you, how do you import cvs data and change the decimal delimiter to (.) instead of (, )? Because if you check Excel file, you can see that comma is used as a decimal delimiter, while in your PBI file, dot is used.