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 Create another date table and use that for slicer and then from that date table, use date range in your measure. let me know if you need further assistance on this.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi parry2k,

 

I know I can create a date table from the new vest date field, but it's the logic I can't get to work to sum dynamically within that measure. 

  • 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. :)