Forum Discussion
ACCUMULATED DAX
Hi all, I'm building a Customer Report and got a problem. Hope someone can help me to solve it :( I want to track Customer's Health. Here is my user table struture: Col1: user's email Col2:...
Hi there,
What you are looking for is the "running Total"
You can easiliy create this whith a Quick measure in PowerBI.
Have a look here: https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures
Good luck!
Robbe
Hi Robble VL, thanks for your quick response.
Please kindly take a look at these pictures in below
When I'm not using Running total Formula, the result will look like:
When I'm adding Running Total DAX,
Active Members running total in Created Date =
CALCULATE(
[Active Members],
FILTER(
ALLSELECTED('base Users'[Created Date]),
ISONORAFTER('base Users'[Created Date], MAX('base Users'[Created Date]), DESC)
)
)
The result is
As you can see, the date 7/10/2019 appeared 12 times, but I just want to see it 1 time. Like this:
7/10/2019 12
7/11/2019 15
7/17/2019 16
7/23/2019 17
7/26/2019 18
Please kindly help me :(
Anonymous ,
So [Active Members] is a measure right? Could you show that measure? If possible, could you also share the sample data?
Regards,
Jimmy Tao
