DAX Measure with a timeline

[Anonymous]

Hi,

I think its a simple question-but dont blame me I dont rlly use Measures often. 

What I've got:

(1) I got a table where Users give an rating from 1-10. I got each day like 50 different ratings. 

(2) a measure to calculate the NetPromoterScore (=difference of promoter 9-10 rating to detractors 0-6 rating): 

NPS SCORE = ([% Promoters]-[% Detractors])*100

(%Promoters and %Detractors are measures too)

What I want

If I try to visualize it. It calculate on each day a new NPS Score. But I want it to be continuous. Each following day it should be added and not calculated new.

Ive got an date column too.

Tanks for any help, I really dont know how to add the time here.

[Anonymous · Accepted solution]

What I understood is that you want cumulative NPS Score.

You can use something along these lines 

Cumulative NPS Score = 
CALCULATE (
    [NPS Score],
    FILTER (
        ALL ( 'Date Table' ),
        'Date Table'[Date Column] <= MAX ( 'Date Table'[Date Column] )
    )
)

Let me know if this works.

Regards,

Aditya