Hi all!
Please, tell me:
-- how to rewrite a DAX-formula for M-notation? it is necessary for slice
I tried to write the correct P-query:
It's amazing, but how add Group (AllExcept) by "ref_Employee" and "ref_ts_Project"?
Regards
Please, tell me:
-- how to rewrite a DAX-formula for M-notation? it is necessary for slice
Code:
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:
Code:
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