Coursera Plus Annual is 40% Off — Ends July 6.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Advanced Power BI: DAX Language, Formulas, and Calculations

via LinkedIn Learning

Write review
Boot.dev Ad

Learn Backend Development Part-Time, Online

Learn More → Train in Data Ad

Master Production-Ready Machine Learning, Step by Step

Learn More →

Overview

AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Learn how to create dynamic business intelligence solutions with the Power BI DAX language, using measures, time intelligence, and advanced calculations.

Syllabus

Introduction
  • Explore advanced features of Power BI
1. DAX Overview
  • DAX intro
  • Variables
  • GENERATESERIES
  • GENERATE and ROW
  • Measure groups and folders
2. Measures
  • DAX measures
  • X functions
  • POWER DAX function
  • Parameter harvesting formulas
  • Filtering and evaluating measures
  • CALCULATE DAX function including filters
  • SELECTEDVALUE
3. Time Intelligence
  • CALENDAR and CALENDARAUTO
  • FIRSTDATE and LASTDATE
  • START or END period
  • DATEADD
  • PARALLELPERIOD
  • Dates period to date
  • DATEBETWEEN
  • PREVIOUS or NEXT period
  • EOMONTH and EDATE
  • DATEDIFF DAX function
4. Advanced DAX
  • ALL and ALLSELECTED DAX function
  • FILTER DAX function
  • BLANK and ISBLANK DAX functions
  • IF
  • DIVIDE DAX function
  • SWITCH
  • Filtering between disconnected tables
5. Advanced DAX Calculations
  • TMDL View
  • Field parameters
  • Calculation groups
  • User-defined functions
Conclusion
  • Next steps and additional resources

Taught by

Helen Wall

Reviews

4.2 rating at LinkedIn Learning based on 52 ratings

Start your review of Advanced Power BI: DAX Language, Formulas, and Calculations

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.