PBI-123
Power BI DAX Formulas and Functions Training
DAX is the language for writing formulas in Power BI to perform complex calculations and create dynamic visualizations that would not be possible using Power BI alone. Our DAX for Power BI training course teaches attendees how to write formulas and functions in Power BI using DAX, create measures, and use the formula bar.
Course Details
Duration
0.5 days
Prerequisites
All attendees must understand the basics of using Power BI and creating reports.
Skills Gained
- Understand DAX fundamentals
- Create calculated columns, calculated tables, and measures using DAX
- Apply essential DAX functions to solve common business problems
- Work with date and time functions in DAX
- Use DAX count functions to summarize data
Course Outline
- Introduction to DAX
- What is DAX?
- Creating Calculations without DAX
- Understanding Measures
- Understanding Quick Measures
- Using the Formula Bar
- Essential DAX Functions Every User Should Know
- SUM() & SUMX()
- AVERAGE() & AVERAGEX()
- MIN() & MINX()
- MAX() & MAXX()
- CALCULATE()
- FILTER()
- ALL()
- RELATED()
- TOTALYTD(), TOTALQTD(), TOTALMTD()
- CONCATENATE() & CONCATENATEX()
- SWITCH()
- DAX Date and Time Functions
- DAY(), MONTH(), QUARTER(), YEAR()
- TODAY(), NOW(), NETWORKDAYS()
- DATEDIFF()
- EDATE()
- EOMONTH()
- Other Date Functions
- DAX Count Functions
- COUNT()
- COUNTA()
- COUNTBLANK()
- COUNTROWS()
- DISTINCTCOUNT() & DISTINCTCOUNTNOBLANK()
- Conclusion
