I have one table named Orders, in which I have Order Date as a column. I was to create a date range slicer for orders made so that slicer will automatically update to new dates/data whenever it will come and simultaneously giving user the functionality to choose manual date range from that slicer only.
I am able to create dynamic date slicer as below:
Last 12 monthes period = IF(
Orders[Order Date] >= MAX(Orders[Order Date]) - 365 && Orders[Order Date] <= MAX(Orders[Order Date]),
Orders[Order Date],BLANK()
)
But it is restricting the user from selecting the custom dates.
I am using very simple visulas:
How can I achieve this please suggest some solutions.
Any help is really appreciated.
Thank you in advance.