How to filter previous month and next five months on date column in power query

[Kusaadigarla01]

Hi team,

I need to show only previous month and next five months data in power query. i have tried with DAX its working but its not working in slicer.

suppose my data is like below, i need to show only previous and next 4 months data as highigheted in screenshot.

Regards,

Kusa

[Ahmedx]

pls try this

= Table.SelectRows(#"Changed Type",

each [Date] >=Date.StartOfMonth( Date.AddMonths( Date.From( DateTime.LocalNow()),-1)) 
 and [Date]<= Date.EndOfMonth( Date.AddMonths( Date.From( DateTime.LocalNow()),3)))