Forum Discussion

francoisl's avatar
francoisl
Icon for Helper II rankHelper II
6 years ago
Solved

date slicer last date

Hi all,    I have found multiple post on the default date slicers but I cannot pinpoint the proper example.    I have a date slice where I want the end date to be today minus 6 months.  Ex  begi...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    Hi francoisl ,

     

    There are two ways you could try.

     

    • Create a measure
    Measure = IF(MAX('Table'[Date]) <= TODAY()-180,1,0)

     

    • Or you could create a new date table and use it as slicer.
    Table 2 = CALENDAR(DATE(2019,1,1),TODAY()-180)

     

     

v-xuding-msft's avatar
v-xuding-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi francoisl ,

 

There are two ways you could try.

 

  • Create a measure
Measure = IF(MAX('Table'[Date]) <= TODAY()-180,1,0)

 

  • Or you could create a new date table and use it as slicer.
Table 2 = CALENDAR(DATE(2019,1,1),TODAY()-180)