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

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
CodeSignal Ad

Learn Generative AI, Prompt Engineering, and LLMs for Free

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
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.