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.

[JuanGerardo]

Hi,

I suggest to use monthstart and monthend functions, something like this:

Sum({<MyDate={">=$(=MonthEnd(AddMonths(MyDate, -1)))<=$(=MonthEnd(MyDate))"}>} Sales)

JG

[praju179396]

Thank you JuanGerardo.

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

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