Finding difference between column values in a matrix

[Anonymous]

I have a table that looks like this:

I want to create a new column that calculate the difference between revenue of:

1. current week - last week

2. current week - 2 weeks ago

3. current week - beginning of quarter

for each of the segment

I also want the formulas to work in a way where everytime there's a new week's data in the matrix, the values update themselves.

I tried creating a Pivot column for the weeks but it does not give me the correct value. 

Any suggestions on how I could accomplish this?

Thanks

[TheoC]

@Anonymous check out this link: https://www.dutchdatadude.com/ultimate-time-based-calculations-cheat-sheet-for-dax-power-bi-including-week-based-calculations/

It will give you everything you need plus more and provide clear directions and clarity during the process 🙂