Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
2 years ago
Solved

Filter for TODAY or null values in PQ

I am trying to filter my query for anything that is blank OR the value of the date is greater than or equal to Today.  When I select today on the custom filter, it enter today's date but I need it to...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi jcastr02 ,

    Here is my sample data:

    Use this M function:

    = Table.SelectRows(#"Changed Type", each [Date] = null or [Date] >= Date.From(DateTime.LocalNow()))

    And the final output is as below:

     

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

jcastr02's avatar
jcastr02
Post Prodigy
2 years ago

Joseph_Fadero12   Thank you .  I tried to put this within the formula, but getting an error - any help is appreciated.  

Joseph_Fadero12's avatar
Joseph_Fadero12
Frequent Visitor
2 years ago

Hi jcastr02 ,

Can you filter rows by error, and share the screenshot?