Forum Discussion
Running total based on multiple column
Hi Team, Please help me on Running total calculation based on multiple columns as a slicers. Please find the below data for your referance. If I select HEAD as A, need output below....
Anonymous So you will never had a Value that is less than a "previous" row? If that is the case then you could do this:
Measure = VAR __Value = MAX('Table'[Value]) VAR __Table = FILTER(ALLSELECTED('Table'),[Value] <= __Value) RETURN SUMX(__Table,[Value])
Anonymous
And, hence, why you need an Index or Date column. No way to solve it if values can be equal or a subsequent value is less than the current value. Just add an Index column in Power Query. Otherwise, you are stuck with a DAX index:
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Mythical-DAX-Index/m-p/1093214#M528
Thank you, I will create INDEX column. 🙂