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.
Go to Solution.
@jackCoD 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])
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
Thanks. The problem was my Baseline calculation as you suggested.
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.