Plotting difference in value between two date ranges

Question

Hi PowerBI community!&nbsp;I've been going round in circles for a couple of days trying to figure this one out so I decided to reach out for some help.&nbsp;I'm working with some time series data (example below - my real data is a bit more complex) and want to be able to plot the&nbsp;difference&nbsp;between the first and last value for a given day range. However, I want this value to be on a bar chart that is updated depending on a filter that is on the page.&nbsp;&nbsp;For example for the data below if I am sepecting the range Day 1 &gt; Day 4 then the value would be&nbsp;5.7-1.5=4.2; if I am selecting the range Day 3 &gt; Day 5 then it would be 3.2-1.7=1.5.&nbsp;DayValue11.522.431.745.753.264.875.386.9&nbsp;I can easily calculate a difference in DAX between each value and the value on Day 0, but this doesn't update with filters etc.&nbsp;&nbsp;Any help with this would be hugely appreciated!

gmsamborn · Accepted Answer

Hi&nbsp;wdbirch19&nbsp;&nbsp;Would something like this help?&nbsp;zMeasure = 
VAR _StartDate = MIN( 'Table1'[Date] )
VAR _EndDate = MAX( 'Table1'[Date] )
VAR _StartVal = 
    CALCULATE(
        MAX( 'Table1'[Value] ),
        'Table1'[Date] = _StartDate
    )
VAR _EndVal = 
    CALCULATE(
        MAX( 'Table1'[Value] ),
        'Table1'[Date] = _EndDate
    )
VAR _Diff = _EndVal - _StartVal
RETURN
    _Diff

OR

zMeasure 2 = 
CALCULATE(
    MAX( 'Table1'[Value] ),
    'Table1'[Date] = MAX( 'Table1'[Date] )
)
-
CALCULATE(
    MAX( 'Table1'[Value] ),
    'Table1'[Date] = MIN( 'Table1'[Date] )
)
&nbsp;&nbsp;I hope this helps.

Forum Discussion

Plotting difference in value between two date ranges

2 Replies

Related content

problem while plotting Scatter plot

Different schema into different destination

correlation matrix / plot

seaborn plot not rendering properly

Cumulative sum from different categories in same plot/table

Day	Value
1	1.5
2	2.4
3	1.7
4	5.7
5	3.2
6	4.8
7	5.3
8	6.9