Multiple IF followed by NOT (syntax error?)

[smoothbrain]

Hey team, 

Recieved a lot of really useful information from this community already! Thank you! 

I'm essentially converting GUID's from Salesforce back to staff names for a visual: 

Staff = 
 IF('DataTable'[Staff GUID]="005Mn1234567", "Joe Bloggs",
 //the above converts the GUID to "Joe Bloggs"
 IF('DataTable'[Staff GUID]="005Mn1234568", "Jane Doe",
 //the above converts the GUID to "Jane Doe"

 
The issue I'm having - is currently I only know a portion of the GUID's, and I'm hoping for those I don't, in the calculated table it will just show the GUID. In my mind it went something like: 

NOT('DataTable'[Staff GUID]=("005Mn1234567", 005Mn1234568"), 'DataTable'[Staff GUID])

ie- if the GUID isn't specified as a staff name, just display the GUID. 

However getting all sorts of sytax errors and #error. 

Anyone have any direction or advice on this one? I'm extremely green with DAX. 

[justinmartin · Accepted solution]

Hey Smoothbrain,

If you want to check if a value is in a list of values, you'd use the following syntax: 

'DataTable'[Staff GUID] IN { "005Mn1234567", 005Mn1234568" }

If you are creating a calculated column, the following pattern might be easier to maintain.

New Column = 
SWITCH (
    'DataTable'[Staff GUID],
    "005Mn1234567", "Joe Bloggs",
    "005Mn1234568", "Jane Doe",
    'DataTable'[Staff GUID]
)

[smoothbrain]

@justinmartin that's done the trick! Thank you!

[smoothbrain]

Hey @justinmartin 
Thanks for helping out! 

I have been creating a calculated colum, so I'll try this format! Thank you!