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.
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!
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |