locked
Show data with Date from 3 months ago forward and data that has no date RRS feed

  • Question


  • I'm in Excel 2016 Power Query if it matters.

    I need to filter a column to show dates from 3 months ago until the end of time as well as any items that have a null date. Have tried several things and done some searches but can't find what I need. Appreciate any help.

    Thursday, March 7, 2019 6:13 PM

Answers

  • Hi there. You can do this by adding a custom step (via the little fx button to the left of PQ's formula bar) with the following M code:

    = Table.SelectRows(PreviousStepName, each [MyDate] = null or [MyDate] >= Date.AddMonths(Date.StartOfDay(DateTime.FixedLocalNow()), -3))

    Ehren

    Friday, March 8, 2019 10:58 PM