Filter for TODAY or null values in PQ

[jcastr02]

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 be the actual date of TODAY().  

[v-junyant-msft · Accepted solution]

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.

[Joseph_Fadero12]

Hi I found an article which I believe should help you achieve what you require

GorillaBI

[jcastr02]

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

[Joseph_Fadero12]

Hi @jcastr02 ,

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