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

amitchandak Still no luck with that. Here's the file - Sample PBX