Forum Discussion

hcova7's avatar
hcova7
Frequent Visitor
1 year ago
Solved

How to modify some DAX measures to solve a Running Total problem

Dear sirs, Please your help for the following DAX measure problem.   I have the following Excel pivot table:     This Pivot Table is built from the following table called "Systems"   ...
  • pcoley's avatar
    pcoley
    1 year ago

    hcova7 
    Please try with this measure:

    RTotal_6 :=
VAR _CurrentDate =
    MAX( 'Calendar'[Date] )
VAR _StartDate =
    CALCULATE(
        MIN( 'Calendar'[Date] );
        ALLSELECTED( 'Calendar' )
    )
VAR _EndDate =
    CALCULATE(
        MAX( 'Calendar'[Date] );
        ALLSELECTED( 'Calendar' )
    )
VAR _Range =
    DATESBETWEEN(
        'Calendar'[Date];
        _StartDate;
        _CurrentDate
    )
VAR _RunningTotal =
    CALCULATE(
        SUMX(
            System;
            'System'[ProfitUSD]
        );
        _Range
    )
RETURN
    _RunningTotal

     

    I hope this help, if so please mark as a solution. Kudos are welcome😀

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

hcova7 
Please try with this measure:

RTotal_6 :=
VAR _CurrentDate =
    MAX( 'Calendar'[Date] )
VAR _StartDate =
    CALCULATE(
        MIN( 'Calendar'[Date] );
        ALLSELECTED( 'Calendar' )
    )
VAR _EndDate =
    CALCULATE(
        MAX( 'Calendar'[Date] );
        ALLSELECTED( 'Calendar' )
    )
VAR _Range =
    DATESBETWEEN(
        'Calendar'[Date];
        _StartDate;
        _CurrentDate
    )
VAR _RunningTotal =
    CALCULATE(
        SUMX(
            System;
            'System'[ProfitUSD]
        );
        _Range
    )
RETURN
    _RunningTotal

 

I hope this help, if so please mark as a solution. Kudos are welcome😀

hcova7's avatar
hcova7
Frequent Visitor
1 year ago

Thank you very much for your perfect solution. You don't know how much time I have been able to reduce with this measure. Warm regards