Running Totals In PowerBI Get Data List.Accumulate()

[Lewa]

Hi all!

Please, tell me:

-- how to rewrite a DAX-formula for M-notation? it is necessary for slice

CALCULATE(
    SUM(Data[Fact]); FILTER(
        ALLEXCEPT(Data; Data[ref_Employee]; 'Data'[ref_ts_Project]); 
        Data[Date] <= EARLIER(Data[Date])
    )
)

I tried to write the correct P-query:

RTList = List.Accumulate(
              FactList, {0}, ( SoFar, ThisStep ) => 
              SoFar & { List.Last( SoFar ) + ThisStep })
#"FFWD Changed Type", "Running Total", each RTList{ [INDEX] })

It's amazing, but how add Group (AllExcept)  by "ref_Employee" and "ref_ts_Project"?

Regards

[Lewa]

Up

[v-huizhn-msft · Accepted solution]

Hi @Lewa,

Please refer to the following threads,

https://social.technet.microsoft.com/Forums/en-US/a1e63005-ead7-46a4-8b48-6f42fd3973fd/runnig-total-...

https://community.powerbi.com/t5/Desktop/How-to-do-a-running-Sum-by-group-in-Power-Query/td-p/290123

Best Regards,
Angelia