topic Multiple IF followed by NOT (syntax error?) in DAX Commands and Tips

Multiple IF followed by NOT (syntax error?)

smoothbrain — Fri, 28 Jun 2024 01:12:34 GMT

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.

Re: Multiple IF followed by NOT (syntax error?)

justinmartin — Fri, 28 Jun 2024 01:56:10 GMT

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

Re: Multiple IF followed by NOT (syntax error?)

smoothbrain — Fri, 28 Jun 2024 02:13:04 GMT

Hey justinmartin
Thanks for helping out!

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

Re: Multiple IF followed by NOT (syntax error?)

smoothbrain — Fri, 28 Jun 2024 02:31:48 GMT

justinmartin that's done the trick! Thank you!