A step by step tutorial of an Actual vs. Budget sales analysis using Power Query And Power Pivot.
A Data Model that contains two Transactional Tables (Actual & Budget).
We will make some smart transformations with Power Query and create a few DAX expressions.
CHAPTERS
02:35 Power Query: Column from Examples
08:50 Power Query: Change Date Type with Locale
10:30 Power Pivot: Create relationships
12:00 Power Pivot: Create DAX Measures
#powerquery #powerpivot #dax #excel #dataanalysis