topic Re: [DAX] Measure which returns the difference (%) between daily totals and a baseline value? in DAX Commands and Tips

[DAX] Measure which returns the difference (%) between daily totals and a baseline value?

Anonymous — Thu, 17 Sep 2020 04:42:50 GMT

Date	Value
01/01/2020	500
...
29/02/2020	650
01/03/2020	700
02/03/2020	600
...
31/08/2020	550

I am calculating a baseline value as the median of January and February values (bolded in table above):

Baseline Value = CALCULATE(MEDIAN('Table'[Value]), 'Table'[Month Number] < 3)

I want to determine the % difference between Baseline Value and all future values (i.e. months >= 3). I imagine the pseudo-code to look something like:

Difference From Baseline = DIVIDE('Table'[Value] - 'Table'[Baseline Value], 'Table'[Baseline Value])

When I attempt to plot Difference From Baseline on a line chart, I get a flat line for all future dates. I am guessing I need to somehow FILTER for each unique date? Any help is much appreciated.

Re: [DAX] Measure which returns the difference (%) between daily totals and a baseline value?

amitjzaveri — Thu, 17 Sep 2020 05:44:11 GMT

Anonymous Please change the baseline formula as follows then it should work

Baseline Value = CALCULATE(MEDIAN('Table'[Value]), MONTH('Table'[Date]) < 3) Difference From Baseline = DIVIDE(SUM('Table'[Value])-[Baseline Value],[Baseline Value])

Example output:

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Cheers!

Re: [DAX] Measure which returns the difference (%) between daily totals and a baseline value?

Anonymous — Thu, 17 Sep 2020 23:16:08 GMT

Thanks. The problem was my Baseline calculation as you suggested.