Power Pivot Principles: PARALLELPERIOD Comparison
4 May 2021
Welcome back to the Power Pivot Principles blog. This week, we are going to compare monthly data again, but this time using on an alternative approach.
If you have read my previous blog, you must be aware that I have been outlining options to look at monthly changes in Sales. Let’s pull the monthly Sales data in a table again to start the process:
This time to analyse month on month performance, let’s compare results with the preceding month, using the PARALLELPERIOD function. The syntax is as follows:
PARALLELPERIOD(dates, number_of_intervals, interval)
I can simply use this to and create the following measure:
=CALCULATE([Sales (including GST)],PARALLELPERIOD('Calendar'[Date],-1,MONTH))
Now, I simply pull this measure into my PivotTable to generate the following results:
Yes, it was simple and like DATEADD.
That’s it for this week!
Come back next week to see how we use the disconnected table for performing a sensitivity analysis by staying tuned for our next post on Power Pivot in the Blog section. In the meantime, please remember we have training in Power Pivot which you can find out more about here. If you wish to catch up on past articles in the meantime, you can find all of our Past Power Pivot blogs here.