Forum Discussion
Datepicker
I need to find a method to put a Date Picker in the reports.
Currently, if I set a fixed start date and end date in the filter, when uploading this report from desktop to online it remains static, which means that when new data is uploaded, the report does not automatically show the most recent dates.
What I need is a dynamic date segmenter that does two things:
1) Automatically update to span from the oldest date to the most recent date available in the loaded data.
2) Allow the user to manually select a date within that range to display the information they need.
Thus, each time the data is updated, the segmenter calendar will also reflect the new date range available.
valmenara , Use DAX to create dynamic dates and use them instead of original
MinDate = CALCULATE(MIN('YourDataTable'[DateColumn]), ALL('YourDataTable'))
MaxDate = CALCULATE(MAX('YourDataTable'[DateColumn]), ALL('YourDataTable'))
2 Replies
valmenara , Use DAX to create dynamic dates and use them instead of original
MinDate = CALCULATE(MIN('YourDataTable'[DateColumn]), ALL('YourDataTable'))
MaxDate = CALCULATE(MAX('YourDataTable'[DateColumn]), ALL('YourDataTable'))