Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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?  
Need Help
Show and Tell
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    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.

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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