Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |