Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
smoothbrain
New Member

Multiple IF followed by NOT (syntax error?)

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. 

1 ACCEPTED SOLUTION
justinmartin
Microsoft Employee
Microsoft Employee

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]
)

View solution in original post

3 REPLIES 3
justinmartin
Microsoft Employee
Microsoft Employee

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]
)

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

Hey @justinmartin 
Thanks for helping out! 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.