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.

  • sivasrao's avatar
    sivasrao
    Icon for Helper III rankHelper III
    3 years ago

    Hi,

    What is the [Order] in the above function?

      • sivasrao's avatar
        sivasrao
        Icon for Helper III rankHelper III
        3 years ago

        Hi, 

        thank you for your quick reply.

        What is in [Order] measure?

        Can you please elaborate on the total function?