Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
5 years ago
Solved

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. ...
Help
amitchandak's avatar
amitchandak
Super User
5 years ago

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

  • Fcoatis's avatar
    Fcoatis
    Post Patron
    5 years ago

    Thank you