Forum Discussion

Alex_Hasan's avatar
Alex_Hasan
Helper II
4 years ago
Solved

Current Date

In a dataset, there is a date dimension table.  1. Assume the current date is 15 Nov, 2016. 2. Make a date slicer so that so we can dynamically check another date.   This is how I made a slicer. ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi Alex_Hasan ,

     

    You can create a new date table via slicer = CALENDARAUTO(). Then put the date in the slicer. Which slicer type is Before.

    Use a measure named current date via max('slicer'[date])  to get the date selected in the slicer.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi Alex_Hasan ,

 

You can create a new date table via slicer = CALENDARAUTO(). Then put the date in the slicer. Which slicer type is Before.

Use a measure named current date via max('slicer'[date])  to get the date selected in the slicer.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.