DAX Measure with a timeline

Anonymous — Tue, 17 Aug 2021 10:27:48 GMT

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.

Re: DAX Measure with a timeline

Anonymous — Tue, 17 Aug 2021 11:29:35 GMT

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

topic Re: DAX Measure with a timeline in DAX Commands and Tips

DAX Measure with a timeline

Re: DAX Measure with a timeline