how to calculate cumulative decrease use DAX

[Anonymous]

Hi, experts, I want to get the gap of the relevant value, for example, the "cal" column in the picture, do you have any solutions?

[Mahesh0016 · Accepted solution]

VAR PreviousRow = CALCULATE( [Orders], OFFSET( -1, ALLSELECTED('Product'[yearmonth]), ORDERBY('Product'[yearmonth], ASC) ) )
RETURN [# Orders] - PreviousRow


Hello @Anonymous ,
I hope this helpful for you if not so can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[sivasrao]

Hi,

What is the [Order] in the above function?

[Mahesh0016]

Hello @sivasrao ,
[Order] is Measure.

[sivasrao]

Hi, 

thank you for your quick reply.

What is in [Order] measure?

Can you please elaborate on the total function? 

[Anonymous]

Thanks, I am not quiet understand [# Orders] of "RETURN [# Orders] " , can you tell me what it stands for? Thanks.