Power query - filter date to show previous 12 months, excluding previous 3 months

[Anonymous]

Hi Everyone,

I'm looking for a way in Power Query to a filter date column to show previous 12 months, but exluding the previous 3 months.

For example, if current month is August, I want to exclude July, June, May, and only see results for April, March, Feb, Jan, Dec, Oct, Sept.

Thank you kindly for your assistance 🙂 

[JoeBarry]

Hi @Anonymous 

In the date column just filter before today. Then Change the code to this at the each part

each [Date] < Date.AddMonths(Date.EndOfMonth(Date.From(DateTime.LocalNow()))+ #duration(1,0,0,0), -4))

Then filter the date to before lets say April and the change the code again at the each part to 

each Date.AddMonths(Date.EndOfMonth(Date.From(DateTime.LocalNow()))+ #duration(1,0,0,0), -15))

Hope this helps

Kind regards

Joe

If this post helps, then please Accept it as the solution