cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lewa Regular Visitor
Regular Visitor

Running Totals In PowerBI Get Data List.Accumulate()

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-huizhn-msft Super Contributor
Super Contributor

Re: Running Totals In PowerBI Get Data List.Accumulate()

2 REPLIES 2
Lewa Regular Visitor
Regular Visitor

Re: Running Totals In PowerBI Get Data List.Accumulate()

Up

Highlighted
v-huizhn-msft Super Contributor
Super Contributor

Re: Running Totals In PowerBI Get Data List.Accumulate()