The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I am creating a custom column using the below IF Condition, syntax shows no error. However, an error is coming in the custom column
this is my query
if[Hour] >= 0 [Hour] <= 6 then "1 AM -6 AM" else
if[Hour] >= 6 and [Hour] <= 12 then "6 AM -12 PM" else
if[Hour] >= 12 and [Hour] <= 4 then "12 PM -4 PM" else
if[Hour] >= 4 and [Hour] <= 10 then "4 PM -10 PM"
else "10 PM - 12 AM"
The error I am getting,
Please advise
Solved! Go to Solution.
missing "and" in the first line?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
248 | |
124 | |
111 | |
78 | |
78 |