Filter greater than today

[CarlBlunck]

Hello,

I have a datetime column that I need to filter so it only shows the values that are greater than today.  My understanding is that if use 

DateTime.LocalNow()

It will give the today's date and the current time.  But I need it to be today's date with 00:00:00  as the time portion.

How do I achieve this?

Thanks

Carl

[v-yueyunzh-msft · Accepted solution]

Hi , @CarlBlunck 

You can use this M language to get " today's date with 00:00:00 ":

DateTime.From(Date.From(DateTime.LocalNow()))

The result is as follows:

Best Regards,

Aniya Zhang

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

[CarlBlunck]

Thanks @v-yueyunzh-msft