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 o...
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

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