Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Caculating Period over Period

Hi,

i'm currently using separate measures to calculate month over month, week over week, day over day variance of the total Sales.

i wonder if there is any DAX can measure those period over period within a single measurement ?

So when i drill down from year >> month >> week >> day it will display the sales of week to week, month to month, year to year variance accordingly to the date hierarchy 

 

Thanks