Forum Discussion

rbustamante's avatar
rbustamante
Icon for Helper I rankHelper I
5 years ago
Solved

Calculate difference between columns in matrix visual

I have the following matrix visual: I need two things when the user clicks on the "Date slicer": 1) dynamically calculate the difference between the ammount of two dates. Ammount of 31/12/202...
Payeras_BI's avatar
Payeras_BI
Icon for Solution Sage rankSolution Sage
5 years ago

Hi rbustamante ,

 

Based on the data you provided here: 

 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-calculate-measure-based-on-previous-date/m-p/1589940 

 

 

mDifference = 
VAR _CurrentDate =
    SELECTEDVALUE ( 'Products (2)'[Date])
VAR _PreviousDate =
    CALCULATE (
        MAX ( 'Products (2)'[Date] ),
        ALLSELECTED ( 'Products (2)'[Date] ),
        KEEPFILTERS ( 'Products (2)'[Date] < _CurrentDate )
    )
VAR _ThisMonth =
    CALCULATE ( SUM ( 'Products (2)'[Amount] ) )
VAR _PreviousMonth =
    CALCULATE (
        SUM ( 'Products (2)'[Amount] ),
        'Products (2)'[Date] = _PreviousDate
    )
RETURN
    _ThisMonth - _PreviousMonth

 

 

Regards,