Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Running Total - Not Showing Cumulative Amount

Hi,   Any idea why this isn't showing the cumulative total but rather the grand total. Must be related to the date. Running Total Hrs = CALCULATE ( SUM ( 'powerbi114 view_finance'[Hrs] ), FIL...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    This is what worked for me.


    Running Tot =
    CALCULATE(
    [Total Hrs]
    , FILTER( ALL( 'powerbi114 view_finance' )
    , 'powerbi114 view_finance'[carer_id] = MAX('powerbi114 view_finance'[carer_id])
    && 'powerbi114 view_finance'[Sched_Start] <= MAX( 'powerbi114 view_finance'[Sched_Finish] )
    && 'powerbi114 view_finance'[date] = MAX('powerbi114 view_finance'[date])
    )
    )

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

This is what worked for me.


Running Tot =
CALCULATE(
[Total Hrs]
, FILTER( ALL( 'powerbi114 view_finance' )
, 'powerbi114 view_finance'[carer_id] = MAX('powerbi114 view_finance'[carer_id])
&& 'powerbi114 view_finance'[Sched_Start] <= MAX( 'powerbi114 view_finance'[Sched_Finish] )
&& 'powerbi114 view_finance'[date] = MAX('powerbi114 view_finance'[date])
)
)