Forum Discussion
Comparing Days Sales
I am trying to calculate Sales This period compared to Sales Previous period, which is a simple formula I know. But what's complicated about this, is the client works on Retail Calendars. So for exam...
Think PARALLELPERIOD will help you here: https://docs.microsoft.com/en-us/dax/parallelperiod-function-dax
Once you have period 1, you can use this with PARALLELPERIOD to get the same period for the prior year.