Custom date filter

Hi mesuyog ,

What's your expected output? If you want to simply apply a date filter, you may drag Date column to Slicer field, then you could custom date period:

Or if you want to re-arrange the date month, for example, 

 2021 December is  from   2021/12/13  to   2022/1/12  

 2022 January     is  from   2022/1/13    to   2022/2/12 

Please create a column:

New YearMonth = 
var _date=IF(DAY([Date])>=13,[Date],EOMONTH('Table'[Date],-1))
return FORMAT(_date,"yyyy mmmm")

And I created another column for sort:

Output:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.