Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Date Slicer and Measure

Hi All,  Can't seem to find a solution and have tried many ways. I have the following measure:    Remaining Shares Unvested = CALCULATE ( SUM( 'Equity'[Share Splits] ), 'EquityFull'[New Vest ...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    Anonymous let's assume your date table is called "Calendar". Try following measure and tweak as per your need.

     

    myMeasure = 
VAR startDate = MIN(Calendar[Date])
VAR endDate = MAX(Calendar[Date])
RETURN

CALCULATE (
SUM( 'Equity'[Share Splits] ),
FILTER( EquityFull,
'EquityFull'[New Vest Date] >= startDate &&
'EquityFull'[New Vest Date] <= endDate

)

     

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous let's assume your date table is called "Calendar". Try following measure and tweak as per your need.

 

myMeasure = 
VAR startDate = MIN(Calendar[Date])
VAR endDate = MAX(Calendar[Date])
RETURN

CALCULATE (
SUM( 'Equity'[Share Splits] ),
FILTER( EquityFull,
'EquityFull'[New Vest Date] >= startDate &&
'EquityFull'[New Vest Date] <= endDate

)

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

That worked. Thanks. :)