Forum Discussion
Running Sum with filter slicer problem m - query
Not totally clear on your scenario, but columns created either with the query editor or with a DAX expressions will not respond slicers. They calculated only when the data model is refreshed. You need to write measures to get filtering by slicers.
Pat
tanks for your answer
very simple
microsoft in quick measure runningsum sample is very very slow for amount of records
Because for every row is recalculate from start to current row
better approach is to run index like idx=idx+1 like while loop
im m query you can use it in List.Generate by passing list column paramter from you table
the problem i in filtering data
the rt start from the base value unlike dax exp
{1,2,3,4,5} list for filtering the number 5 the rt exp will be 10 instead 5
this is the value that we need in m - query before the exp dax
There may be a more optimized way to write your DAX measure, so you may want to share that. For the M solution, can you provide a small sample table that shows your desired output.
Pat