Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)
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.
Solved! Go to Solution.
@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!
@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!
Thanks. The problem was my Baseline calculation as you suggested.