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.
Hello
Any idea why the Power Query below does not work?
#"Filter Today" = Table.Join(Table.TransformColumnTypes(Table.FromRecords({[Date = FormatDateTime.Date(DateTime.LocalNow())],[Date = Date.AddDays(DateTime.Date(DateTime.LocalNow()),-1)]}), {{"Date", type date}}, "en-US"), "Date", #"Changed Type", "Date"),
Thanks!
Solved! Go to Solution.
Hi @UsePowerBI
As @AlexisOlson mentioned, you need to replace FormatDateTime.Date() with DateTime.Date()
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @UsePowerBI
As @AlexisOlson mentioned, you need to replace FormatDateTime.Date() with DateTime.Date()
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
"FormatDateTime.Date" is not a valid function name.
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.