Hack Data Model, Date Table & DAX Measures Without Buying Power Pivot

Hack Data Model, Date Table & DAX Measures Without Buying Power Pivot

Discover advanced Excel techniques in this 36-minute tutorial video that demonstrates how to build a complete Data Model with relationships and DAX formulas without purchasing Power Pivot in Excel 2016. Learn to import tables, create relationships, and construct a Date Table using functions like YEAR, MONTH, and TEXT. Master DAX measures with functions such as CALCULATE, SAMEPERIODLASTYEAR, TOTALYTD, and DATEADD. Explore the creation of variables in DAX using VAR and RETURN keywords. Gain insights on efficient practices, including avoiding Implicit Measures and utilizing HASONEVALUE for hiding grand totals. Download accompanying files to practice along and reinforce your understanding of these powerful Excel data modeling techniques.