Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi
This might sound silly but I'm not able to get around this problem.
= If (StartDate > Today()) then "Hello" Else "Bye"
Now() / Today () function just doesn't work
Thanks for the hepl!
Solved! Go to Solution.
Try with this
if [Calendar] > DateTime.Date(DateTime.LocalNow()) then "Hello" else "Bye" )
Thanks @Vvelarde I've tried this
Error: Expression error: The name 'If' wasn't recognized. Make sure it's spelled correctly.
Are you in Query Editor?
Yes and adding a new column in query editor
Try with this
if [Calendar] > DateTime.Date(DateTime.LocalNow()) then "Hello" else "Bye" )
In Query Editor, capitilaization matters. Use if instead of If in your original statement.
Here is more information on IF http://www.excelguru.ca/blog/2014/08/27/the-if-function-in-power-query/
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
209 | |
118 | |
116 | |
81 | |
74 |