[5/5] Power Pivot's Data Model and DAX formula in a nutshell (The Power Series Way, Part 2)

How to:

  1. Create relationships between tables.

  2. Write formulas exclusive to Power Pivot that simplifies the formula-writing process for L12M, L12M_Avg, YTD and FTYD figures.  

[30 min read]

Read More

[1/5] How to set up a reference date table and summarise figures to get absolute and Year-On-Year (YOY) monthly figures

How to:

  1. Get dates into a readable format that allows for easy referencing further on in the set-up process.     

  2. Set-up a date table that automates the updating of time period parameters.   

  3. Sum up figures based on specific criteria (i.e. time period / product category).

  4. Manage situations where an error value is returned.

[9 min read]

Read More