Forum Discussion

Anonymous

Not applicable

7 years ago

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:...

Impactful Individual

7 years ago

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

Anonymous
Not applicable
7 years ago
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
  7 years ago
  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