Forum Discussion

dennisdepoorter's avatar
dennisdepoorter
Icon for Helper I rankHelper I
8 years ago
Solved

Select days from relative date slicer

Hi All,   I like to select the days out of the relative date slicer.   De reason is that we always make predictions based on L30D. But of we want to make the predictions on L120D, we need to reca...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    8 years ago

    hi, dennisdepoorter

     You may try to use this formula as below:

    Measure = DATEDIFF(MIN('Order'[ActivatedDate]),TODAY(),DAY )+1

    Result:

    Best Regards,

    Lin

     

     

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

hi, dennisdepoorter

 You may try to use this formula as below:

Measure = DATEDIFF(MIN('Order'[ActivatedDate]),TODAY(),DAY )+1

Result:

Best Regards,

Lin