Filter Dataset in Power Query for 2 months ago

[Anonymous]

Hi All

I am able to filter my dataset for Last month using

= Table.SelectRows(Source, each Date.IsInPreviousMonth([LoadDate]))

How would I amend this so I filter for 2 months ago only?  So not the last two months as that would include last month, I only want the data for two months ago

Hope that is help. any assistance appreciated!

[bhanu_gautam · Accepted solution]

@Anonymous , For filtering data for last twomonths you can use

let
Source = ... , // Your existing data source
TwoMonthsAgoStart = Date.StartOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()), -2)),
TwoMonthsAgoEnd = Date.EndOfMonth(Date.AddMonths(Date.From(DateTime.LocalNow()), -2)),
FilteredRows = Table.SelectRows(Source, each [LoadDate] >= TwoMonthsAgoStart and [LoadDate] <= TwoMonthsAgoEnd)
in
FilteredRows