Forum Discussion
Difference between records
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
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-5c3243d1f9
2 Replies
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-5c3243d1f9Thank you
