Calculate within lines

[AlexAlexB]

I´m trying to calculate within lines in PowerBI. My table contains a timestamp an a countervalue, which is growing every hour. I want calculte the hourly delta / groth. The Picture show the calculation in MS Excel, which is quite easy. But i didn´t find a way to realize it in MS Power BI DAX. Can somebody help me.

 

[v-chuncz-msft · Accepted solution]

@AlexAlexB 

You may refer to the post below to add a calculated column.

https://community.powerbi.com/t5/Desktop/Finding-the-previos-occurrence-within-same-table-based-on-o...