Token Comma expected - Power BI query editor

Lucille Moore 1 Reputation point
2022-06-21T10:50:08.467+00:00

IF([Status] = "1. 1st Fix Partitions Complete" then 1 else if [Status] = "3. 2nd Fix Partitions Complete" then 2 else if [Status] = "4. 1st Fix M&E Complete" then 3 else if [Status] = "5. 1st Fix Ceilings Complete" then 4 else if [Status] = "7. 2nd Fix Ceilings Complete" then 5 else if [Status] = "Not Inspected" then 6 else 7)

The error is showing up for the "1 else" which I have highlighted in bold, does anyone know how to fix this?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
34,864 questions
0 comments No comments
{count} votes