PQ filter to query todays date

[rjmdc]

hi
i have a spreadsheet with a column of dates
at the moment ifiletr manually to keep the blanks and anything from today - 3 months
i created 2 separate queries ont todaysdate and drilled down and then one theree months drilled down
how can i pull in these queries to a PQ to use a filter keep blanks and >Three Months and <Today
filter on the sheet doesnt work because i can do between this date and that date but then i lose my blanks

 

[lrobbo314]

Something like this.

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    SR = Table.SelectRows(Source, each 
        let 
            today = DateTime.LocalNow(),
            minDate = Date.AddMonths(today,-3),
            x = [Dates] >= minDate and [Dates] <= today or [Dates] = null
        in 
            x
        )
in
    SR