Current Date

[Alex_Hasan]

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. But I cant understand what the current date is 15 Nov, 2016  is. All I know ablout current date is Today () function. for your better understanding, I am sharing the dataset.  also. https://drive.google.com/file/d/1FhyexInp3ghfep3BG0wnPUoFX_Ki1O9m/view?usp=sharing  

[v-chenwuz-msft · Accepted solution]

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.

[TomMartens]

Hey @Alex_Hasan ,

unfortunately, this is not possible because a slicer does not accept a measure that provides a "default" value, e.g., a measure that returns the value using the DAX function TODAY().
Maybe using the relative date options provide what you are looking for: Use a relative date slicer or filter in Power BI - Power BI | Microsoft Docs
But as I already mentioned, there is no "default" value for slicers.

Regards,

Tom