Forum Discussion
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. 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
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.
2 Replies
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
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.
