Forum Discussion
AllanBerces
Post Prodigy
Post ProdigyRunning Total from a measure
Hi Good day, How to create runing total from a measure. I try the quick measure but it just copy the data, the running total value should be -1 day from current date. (Let say toaday is Feb 27 the v...
Musadev
Resolver III
Resolver IIIHi AllanBerces
I have used a column instead of measure, you need to do mecessary changes for your data.
Here is the DAX code.
Running Total =
VAR CurrentDate = MAX('tbl2'[date])-1
RETURN
CALCULATE(
SUM(tbl2[Earning]),
FILTER(
ALL(tbl2[date]),
tbl2[date] <= CurrentDate
)
)Here is the output for my custom data.
Good Luck!
AllanBercesPost Prodigy
Post ProdigyHi Musadev,
Thank you for your reply, but cant add column on my table.
Thank you
- Musadev
Are you missing some records or not able to map them with your data?
If you have similar table data and columns as shared in the query, i will update my data and will share it with you.- AllanBerces
My Earning is from other table and measure and filter as per each category.
- Musadev
Can you share the Datamodel image with relationships?