Forum Discussion

madlfc87's avatar
madlfc87
Icon for Helper I rankHelper I
1 year ago
Solved

Difference between values of two different days

Hi everyone,   I would like to subtract the values of these two dates but I'm having a hard time doing it. I've tried the below formula but it doesn't work.   I tried    Previous Total = SUMX(...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi madlfc87 -Instead of filtering on specific dates within the SUMX function, you can use measures that directly filter the values based on the selected date.

     

    Current Total1 =
    CALCULATE(
        SUM('Cash_all locations'[Balance USD]),
        'Cash_all locations'[Date] = DATE(2024, 8, 31)
    )
     
    Previous Total1 =
    CALCULATE(
        SUM('Cash_all locations'[Balance USD]),
        'Cash_all locations'[Date] = DATE(2024, 8, 15)
    )
     
    Difference = [Current Total1] - [Previous Total1]
     

     

    Check the attached pbix file FYR.

     

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
1 year ago

Hi madlfc87 -Instead of filtering on specific dates within the SUMX function, you can use measures that directly filter the values based on the selected date.

 

Current Total1 =
CALCULATE(
    SUM('Cash_all locations'[Balance USD]),
    'Cash_all locations'[Date] = DATE(2024, 8, 31)
)
 
Previous Total1 =
CALCULATE(
    SUM('Cash_all locations'[Balance USD]),
    'Cash_all locations'[Date] = DATE(2024, 8, 15)
)
 
Difference = [Current Total1] - [Previous Total1]
 

 

Check the attached pbix file FYR.