Forum Discussion
Solved
Using DAX Calculate in a column to get a column based running total
Hello, I am trying to create a column that will show much a running total as of a given date. I have the function working as you can see below where it is showing me the running total sum of ever...
I was able to solve this
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Change-DAX-calculated-column-using-EARLIER-Function/m-p/3842788
Using this other thread. Unsure how to mark as solved.
suparnababu8
Super User
Super UserHi BradyVan
Please use the below DAX measure to get desired output.
RunningTotal =
CALCULATE(
SUM(OnHandHistory[QuantityMoved]),
FILTER(
ALLEXCEPT(OnHandHistory, OnHandHistory[Item_No], OnHandHistory[Location_Code]),
OnHandHistory[Month] <= EARLIER(OnHandHistory[Month])
)
)
I implemented the same in my PBI desktop and am getting correct results as per your requirement.
Unfortunately, I don't have access to add pbix file here. Just implement the above DAX code. Please let me know if it works.
Thank you!
Regards
Suparna Babu