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

Deduct cumulative values in a previous rows

Hello,

 

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?

2 REPLIES 2
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 !





Highlighted
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.