Forum Discussion
SUM function
Hi, I'm confused by SUM/SUMX formulas. I want to create a column called Total Time that: - has 0 in the first row - starting from the second row down every cell is a sum of a current value from a c...
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: