Forum Discussion

KH11NDR's avatar
KH11NDR
Icon for Helper IV rankHelper IV
8 years ago
Solved

Date slicer, need the difference of value

Hi,

 

I have a field with values in them, let's say it's called sales.  And I have a master calendar table linked via Date field.  What I'm trying to show in a table or chart is, what's the difference in value by the two dates selected with the slicer.  Just say I picked 01/06/2018 to 31/06/2016 and the value on the 1st of July was 10 and on the 31st July it was 20, I want my result to show +10, as that's the variance from starting and ending points.

 

Thanks in advance.

1 Reply

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    KH11NDR,

     

    You may use FIRSTDATE Function and LASTDATE Function to calculate the variance from starting and ending points. For example:

    Measure =
CALCULATE ( SUM ( 'Table1'[Value] ), LASTDATE ( 'Table1'[Date] ) )
    - CALCULATE ( SUM ( 'Table1'[Value] ), FIRSTDATE ( 'Table1'[Date] ) )