Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
127 | |
109 | |
93 | |
70 | |
67 |