Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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: Power Query Current Date Filter - Microsoft Power BI Community
This seemed to be the solution
let
#"Gefilterte Zeilen1" = Table.SelectRows(#"Gefilterte Zeilen", each [Nächster Termin] <= DateTime.LocalNow())
in
#"Gefilterte Zeilen1"
but then I get this error message:
Sorry - this is German.
But it is saying that < cannot be used for DateTime and Date.
What can I do?
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.