From the Book - Second edition.
A revolution built on YOU
Power Pivot and the Power BI family
making sense of the various versions
Loading data into Power Pivot
Intro to calculated columns
Introduction to DAX measures
The "golden rules" of DAX measures
your new favorite function
the "remove a filter" function
Thinking in multiple tables
taking stock of your new powers
Introducing the FILTER() function, and disconnected tables continued
Introduction to time intelligence
IF(), SWITCH(), BLANK(), and other conditional fun
SUMX() and other X ("iterator") functions
Power Query to the rescue
"Complicated" relationships
Row and filter context demystified
Time intelligence with custom calendars
greatest formula in the world
Advanced calculated columns
New DAX functions ... and variables!
the importance of a server
Can we ask you for a special favor?
Power Pivot and SSAS Tabular
two tools for the price of one (again!)
the end of GetPivotData()
Some common error messages
the most powerful feature of Power Pivot.
