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 differe...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    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] ) )
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] ) )