Caculating Period over Period

[Anonymous]

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 

[Greg_Deckler · Accepted solution]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, I am thinking about something like ISINSCOPE: https://docs.microsoft.com/en-us/dax/isinscope-function-dax

[Anonymous]

Thanks, it work