Showing results for 
Search instead for 
Did you mean: 
MariosChr90 Member

Deduct cumulative values in a previous rows



I have a report which automatically captures data from sensors which have a counter.


Every month I get the cumulative amount in each sensor and I deduct it from the cumulative amount of the previous month so I can have the total monthly amount.


For example if the sensor cumulative amount in August is 8000 and the cumulative amount in July was 7000, this means that I had 1000 units in August.


How can I do it in Power BI so can perform a monthly analysis?

Super User
Super User

Re: Deduct cumulative values in a previous rows

@MariosChr90  Please post some sample data and expected output which will be helpful to provide an accurate solution.

Did I answer your question? Like and Mark my post as a solution !

Proud to be a Datanaut !

Community Support Team
Community Support Team

Re: Deduct cumulative values in a previous rows

Hi @MariosChr90 ,


Please provide a dummy sample. The DAX formulas depend on the data structure.



Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.