This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

how to calculate cumulative decrease use DAX

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?

null_0-1671167005760.png

 

1 ACCEPTED SOLUTION
Mahesh0016
Super User
Super User

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.

View solution in original post

5 REPLIES 5
Mahesh0016
Super User
Super User

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.

Hi,

What is the [Order] in the above function?

Hello @sivasrao ,
[Order] is Measure.

Hi, 

thank you for your quick reply.

What is in [Order] measure?

Can you please elaborate on the total function? 

 

Anonymous
Not applicable

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

Helpful resources

This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.