Subtract values of previous date from current date

[Anonymous]

Hello,

I'm currently trying to create a new measure to find the difference of values between the current week ending date and the previous. The would be a running date, so it would always the difference between the  most recent week ending date and the last.

The highlighted column is the desired output. Would you guys know how to best go about this?

Thank you in advance!

[TomMartens]

Hey @Anonymous ,

you can solve the "previous" value challenge using the DAX function OFFSET, I recommend reading these articles:

• https://pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/
• https://www.minceddata.info/2022/12/14/unlock-an-ample-new-world-by-seeing-through-a-window/

I think your description "... current week ending date and the previous ..." does not match the data of the screenshot, as the distance between the two dates is 24 days.

Hopefully the articles will help to tackle your challenge.

[Anonymous]

Thank you for the links! I went back and changed the dates to match what I actually meant. From week ending 11/25 to week ending 12/2

[TomMartens]

Hey @Anonymous ,

create a pbix that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Uploade the pbix to OneDrive, Google Drive, or Dropbox and share the link. If you are using a spreadsheet to create the sample data instead the manual input method share the spreadsheet as well.

Explain the expected result based on the sample data you provide.

Regards,

Tom