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

Anonymous's avatar
Anonymous
Not applicable
7 years ago
v-cherch-msft wrote:

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


Cherie, to be honest, I get confused by the difference between calculated columns and measures. I believe my Done column IS a measure and that is causing a problem with the formula you suggest. I cannot choose it for this part of your formula:

SUM ( Table[Done] ),

Plenty of columns show, but not my Done column. 

 

Here is how I get my Done column: Done = CALCULATE(COUNT(Issues[Key]),History[History New Value]="Done")