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.
Hey Everyone - I have this formula in Power Query that looks like this:
=if [Provided Date]>= Date.From(DateTime.LocalNow() then "Up To Date" else 0
I'm trying to have it look at the "provided date" and if it's >= whatever the current date is, list it as "up to date".
I keep getting a token comma expected error and can't figure this one out - can anyone help?
Solved! Go to Solution.
You need to close parentheses for your Date.From. Add another after .LocalNow())
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
You need to close parentheses for your Date.From. Add another after .LocalNow())
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thank you for your help.
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.