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
Wave a DAX wand and your Excel report is ready - Step in through the magic door and discover new reporting powers in this alternate world. Powers you always wished you had but could only fantasize about.
[4 min read]Read More
THE Power Pivot function you need to know. Easily extract a subset of data to do complex calculations with in a jiffy. Say goodbye to random data trawling and hello to top-notch angling!
[6 min read]Read More
Solutions for Data Crunchers and Businesses.