Forum Discussion
Helper ISum columns not working
1125NEWBIUSER If you want to add four fields together, just add them together, no need for a DAX function:
[Measure] + [Measure 1] + [Measure 2] + [Measure 3]
Same thing for columns.
I feel like you are overcomplicating your running total. I just posted a Better Running Total that demonstrates a super simple approach to this. https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Running-Total/td-p/2755666
Would need sample data and expected output to go further.
Community Champion1125NEWBIUSER If you want to add four fields together, just add them together, no need for a DAX function:
[Measure] + [Measure 1] + [Measure 2] + [Measure 3]
Same thing for columns.
I feel like you are overcomplicating your running total. I just posted a Better Running Total that demonstrates a super simple approach to this. https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Running-Total/td-p/2755666
Would need sample data and expected output to go further.
Helper IGreg_Deckler for the first, that did the trick, thank you very much.
For the second item, that worked as well. I added my additional features to VAR __Table and it matches the other formula I used. Is the below enough for the data set example? Below is Table 1 (Left), I have the RT versus the orders per day. Table 2 (Right), I have same thing but filtered to just see this month. The running total adjusts to filtered date of what I want to show in chart versus I want the formula to be static so I can see the left results but at a period of time.
Thanks, Chris