Forum Discussion
Custom Column for Shift
I have a column with the hour of the day noted, and need to figure out shift based on it. For example: Between Hour 6 and Hour 18 its supposed to be 'First Shift' and Between Hour 18 and Hour...
Power Query is case sensitive. Use if , not IF.
Hi Anonymous,
As lbendlin said, it seems like you used the wrong if statement keywords. M query expression and functions are case sensitive on these keywords, you can take a look at the official document to know more about these:
M Language Conditionals - PowerQuery M | Microsoft Docs
Regards,
Xiaoxin Sheng