Difference between records

[Fcoatis]

Hello all,

Need help to figure out how to solve this. I have managed to create a pivot table as a result from my model:

and I need a mesure to calculate the difference between records. Note: the dates are non contiguous as there are non working days. End result woul be like this:

I tried show values as difference in the PT with no success. I really need a mesure to calculate this.

Any help would be appreciated

Fabio Coatis

[amitchandak · Accepted solution]

@Fcoatis , There is no row level operation in power bi, You have to create a measure, with help from date table

You can get a measure like

Last Day Non Continuous = CALCULATE([sales],filter(ALLSELECTED('Date'),'Date'[Date] =MAXX(FILTER(ALLSELECTED('Date'),'Date'[Date]<max('Date'[Date])),'Date'[Date])))

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[Fcoatis]

Thank you