Calculate difference between measure at point in time and previous week

[diogobraga2]

The goal is to create a 'New Measure' to calculate the diffence between measure at point in time and previous week. 

pbix file is here 

[v-lili6-msft]

hi @diogobraga2 

Just use DATEADD to create a meausre as below:

https://docs.microsoft.com/en-us/dax/dateadd-function-dax

New Measure = [Total Returning W]- CALCULATE([Total Returning W],DATEADD('Dates Adj'[Date],-7,DAY))

Result:

Regards,

Lin

[diogobraga2]

Thank you @v-lili6-msft! It looks good, the only minor adjustment is to not show the variance when Total Returning is null. What's your suggestion? See 8/9/2020 below. 

[richbenmintz · Accepted solution]

Hi @diogobraga2,

You can expand the calc provided by @v-lili6-msft like

New Measure = IF([Total Returning W]<> BLANK(),[Total Returning W] - CALCULATE([Total Returning W],DATEADD('Dates Adj'[Date],-7,DAY)), Blank())

Hope this Helps,
Richard
Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up! 

[diogobraga2]

Thank you so much!

[harshnathani]

Hi @diogobraga2 ,

See this blog for week calculations

https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[diogobraga2]

For my purpose, I think it's best to have it as a 'New Measure' instead of a 'New Column.' The pbix is included for anyone willing to show how it's done.