I want to show data like" if the user selectsJan 2022 the start date should be 31/12/2021 and the end date should be 31/01/2022.

[praju179396]

Hello,

The requirement is like

if the user selects Jan 2022 the start date should be 31/12/2021 (start of the month [minus] 1 day) and the end date should be the end of the month ie. 31/01/2022.

[MarcoWedel]

StartDate:
Date(MonthStart(SelectedDate)-1,'DD/MM/YYYY')

EndDate:
Date(MonthStart(SelectedDate,1)-1,'DD/MM/YYYY')

[praju179396]

Thank you Marco.

 I want to apply logic in editor for the Month filter.

If I click on Jan it will work for entire dashboard.