Create relationships between tables.
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
How to write Excel formula that automatically update:
YTD and FYTD figures when “latest month” parameter changes.
Last year’s YTD and FYTD figures when “latest month” parameter changes.
[7 min read]Read More
How to write Excel formula that:
Automatically updates L12M Total and L12M Average figures when “latest month” parameter changes.
Returns accurate summation of figures in the event of insufficient data to sum up.
[20 min read]Read More
Get dates into a readable format that allows for easy referencing further on in the set-up process.
Set-up a date table that automates the updating of time period parameters.
Sum up figures based on specific criteria (i.e. time period / product category).
Manage situations where an error value is returned.
[9 min read]Read More
Solutions for Data Crunchers and Businesses.