Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |