Forum Discussion
project101
4 years agoFrequent Visitor
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]) }