Forum Discussion
valmenara
1 year agoNew Member
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,...
- 1 year ago
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')) - 1 year ago
bhanu_gautam
1 year agoSuper User
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'))