Forum Discussion
Token Comma Expected Error
Hello,
I'm trying to run the following formula in a custom column and its generating a token comma error. Can anyone review and let me know what's missing?
Thanks!
IF([Primary Home Address Line 1]<>[OG Census_Sheet.Primary Home Address Line 1] or [Primary Home Address Line 2] <> [OG Census_Sheet.Primary Home Address Line 2] or [Primary Home Address Line 3] <> [OG Census_Sheet.Primary Home Address Line 3] or [#"Primary Home Address - City"] <> [#"OG Census_Sheet.Primary Home Address - City"] or [#"Primary Home Address - State"] <> [#"OG Census_Sheet.Primary Home Address - State"] or [#"Primary Home Address - Postal Code"] <> [#"OG Census_Sheet.Primary Home Address - Postal Code"] then "flag" else " "
5 Replies
This the correct syntax
IF([Primary Home Address Line 1]<>[OG Census_Sheet.Primary Home Address Line 1] or [Primary Home Address Line 2] <> [OG Census_Sheet.Primary Home Address Line 2] or [Primary Home Address Line 3] <> [OG Census_Sheet.Primary Home Address Line 3] or [#"Primary Home Address - City"] <> [#"OG Census_Sheet.Primary Home Address - City"] or [#"Primary Home Address - State"] <> [#"OG Census_Sheet.Primary Home Address - State"] or [#"Primary Home Address - Postal Code"] <> [#"OG Census_Sheet.Primary Home Address - Postal Code"] , "true" , else)https://community.powerbi.com/t5/Desktop/Custom-Column-Query-If-ands-or/td-p/1637388
Use then and else like this