Forum Discussion
Sort column by today's date
Hi I wish to filter Lease end date column by today's date which is available in table in query editor Please help
Anonymous ,
= Table.SelectRows(#"Changed Type1", each [date] = Date.From(DateTime.LocalNow()))
You don't need to create a column.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Can I have a working file for my reference