I want to create a new column to show for each office its use type, following these rules:
Rule Use typeIf
any of the 3 Use columns is office Office, etc
Otherwise OtherBelow is the table,
Go to Solution.
Please look at my test
Modeling->New column, paste your formula
I'm afraid you were using edit queries.
I wrote the formula shown below but I get an error "Token Comma expected"IF([Use1] = "office" || [Use2] = "office" || [Use3] = "office", "Office, etc", "Other")
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!