Forum Discussion

project101's avatar
project101
Frequent Visitor
4 years ago

Running Sum with filter slicer problem m - query

using Running Sum in m- query  have better   performance than dax exp
the only problem is using slicer  like dates 
we gat the base values of rt 
is not Recalculationthen the values after filter
??
the function 
= (val as list ) as list =>
let
dd=List.Generate(
()=>[ xx =0 , zz=val{0} ],
each [xx] <=List.Count(val) ,
each [ xx=[xx]+1 , zz = [zz] + val{ [xx]+1 } ] , each [zz]

) in dd


and then
Table.FromColumns(

{ aaa[n] ,aaa [val] , fxRunTotal(aaa[val]) }