cancel
Showing results for
Did you mean:
Frequent Visitor

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

 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.

1 ACCEPTED SOLUTION

Accepted Solutions Resolver II

@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])``````

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

Cheers!

2 REPLIES 2 Resolver II

@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])``````

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

Cheers!

Frequent Visitor

Thanks. The problem was my Baseline calculation as you suggested. Announcements #### Power Platform Community Conference

Check out the on demand sessions that are available now! #### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella. Top Solution Authors
Top Kudoed Authors
Users online (2,147)