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 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 :(
v-yuta-msft
Community Support
Community SupportAnonymous ,
So [Active Members] is a measure right? Could you show that measure? If possible, could you also share the sample data?
Regards,
Jimmy Tao