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...
Thanks for this. Can I ask you to kindly elaborate, as I don't quite understand?
What would the formula look like? I tried this, but I think I'm misunderstanding you.
Sales PY Parallel = CALCULATE('Sales Fact Table'[Total Sales],PARALLELPERIOD('Fiscal Calendar','Fiscal Calendar'[Fiscal Period],MONTH))
Below is essentially what I am looking for