Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Aggregating calculated data

I am tring to aggregate data I have in a column by adding the data in the current row to all the previous rows. Sample data below shows the data in the Done column that I would like to aggregate to p...
Need Help
Show and Tell
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous

 

It seems you need a measure instead of calculated column. You may add index for your data in query editor. Then use 'sort by column'. Then you may get the measure as below. Please let me know if the solution makes sense.

Cumuluative Done =
CALCULATE (
    SUM ( Table[Done] ),
    FILTER ( ALL ( Table ), Table[Index] <= MAX ( Table[Index] ) )
)

 

Regards,

Cherie