Forum Discussion

RonBee's avatar
RonBee
Regular Visitor
4 years ago
Solved

Calculate difference betweeb two rows with functioning slicer

Hello Power BI community,   I am trying to get the difference between two rows of a time series data, and my raw data looks like this:     What I want to achieve is the difference between ...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi RonBee ,

     

    I think the most appropriate approach is to create a measure using DAX.

     

    Measure = 
VAR previous_day =
    CALCULATE (
        SUM ( 'Table'[Ordered Qty] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] = MAX ( 'Table'[Date] ) - 1 )
    )
RETURN
    IF ( previous_day <> BLANK (), SUM ( 'Table'[Ordered Qty] ) - previous_day )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi RonBee ,

 

I think the most appropriate approach is to create a measure using DAX.

 

Measure = 
VAR previous_day =
    CALCULATE (
        SUM ( 'Table'[Ordered Qty] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[Date] = MAX ( 'Table'[Date] ) - 1 )
    )
RETURN
    IF ( previous_day <> BLANK (), SUM ( 'Table'[Ordered Qty] ) - previous_day )

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

RonBee's avatar
RonBee
Regular Visitor
4 years ago

This solution works! Thank you so much. 🙂