Show difference across rows in a query

[FMD89]

Hi,

I have a data set that will be updated weekly. The format is basically;

Week	Entity A	Entity B	Entity C
13/07/2022	500	900	1000
20/07/2022	200	800	1000
27/07/2022

I would like to add a measure that will show the difference per week for each entity when the table is updated to contain a value.

So Entity A would show a 300 value for 20/07 for example

I am struggling to get this to work using calculated columns or measures from resarching the forum if someone could assist?

Thank you

[Ashish_Mathur · Accepted solution]

Hi,

Download my PBI file from here.

Hope this helps.

[lbendlin]

That should be relatively straightforward.  For each cell in your visual you grab the current date, then you calculate the largest date that is smaller than the current date, and then you retrieve the column value for that penultimate date.  You meant to say -300, right?