Jun 13, 2022 12:00 AM

Learn Power Pivot & DAX - 20 Beginner to PRO Examples by Chandoo

External YouTube Channel

Chandoo has taken on the deep dive on the DAX. DAX is a collection of functions, operators, and constants that can be used in a formula or expression to calculate or return one or more values. In simpler terms, DAX helps you create new information from data that is already in your mod

Chandoo “DAX (Data Analysis Expressions) is the language used by Power Pivot (and Power BI) to build calculations and to analyze data. If you want to be good in Power BI, then you must learn DAX. In this comprehensive video, learn how to get started and use DAX for many practical scenarios with 20+ examples.”

  • What is DAX & Power Pivot?
  • How to create and edit measures in Power BI?
  • Evaluation Context explained
  • Customizing the DAX measure display settings
  • Reusing DAX measures to build complex calculations
  • How to use CALCULATE() to change the "FILTER" criteria
  • DAX Measures vs. Columns
  • Using Variables in DAX
  • OR conditions, IN operator in DAX
  • DAX tips & guidance to improve your skills

Blank Power BI File (with data model) to follow along:

https://files.chandoo.org/pbix/gettin...

Completed Power BI File (with 20 DAX examples)

https://files.chandoo.org/pbix/gettin...