Forum Discussion
Solved
Filter in PowerQuery dates <= today
I need to filter a table in PowerQuery for dates <= today. As I have learned already this cannot be done within a wizard or so but must be done in M-Code. I already have seen this thread: Solved: ...
Hi cosmicyes ,
The data format are different. DateTime.LocalNow() return DateTime where your column data type is Date.
You can define the column to datetime before you apply filter to rows; or you can date Date.From() Date.From(DateTime.LocalNow())
Regards
KT
Hi cosmicyes ,
The data format are different. DateTime.LocalNow() return DateTime where your column data type is Date.
You can define the column to datetime before you apply filter to rows; or you can date Date.From() Date.From(DateTime.LocalNow())
Regards
KT
