Forum Discussion
SUM function
Anonymous , You have add an index column
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
Cumm = CALCULATE(SUM(Table[time hrs]),filter(all(Table),Table[index] <=maxx(Table,Table[index])))
Hi amitchandak thanks for that!
I've forgot to add a column called step_no.
There is one problem, this measure/column adds new rows:
Original table visualization (target_duration is the time column in my post):
After adding the measure:
Anonymous , Just check in visual table, does target duration has an aggregation, seem like do not summarize option on that. If so make it Sum.
amitchandak changed it to Sum. The same result.
amitchandak can I create an index column that copies the column step no? If i just add the index column (from 1), the order is different from the order in step no