Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Filter Dataset in Power Query for 2 months ago

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!

Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    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

1 Reply

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

    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