topic Re: IF DAX code help in DAX Commands and Tips

IF DAX code help

JamesMurg — Fri, 11 Aug 2023 09:34:28 GMT

Morning all, HAPPY FRIDAY!!

Please could someone help with the below DAX code as it will not work for me 🙂

Column 2 =

IF(AND(

'Report 1'[Destination ID]="IOMA",('Report 1'[Destination ID]="IOMRT", 'Report 1'[Destination ID]="UK653", 'Report 1'[Destination ID]="IOM"

"Isle of Man")

James

Re: IF DAX code help

Fabrizio1 — Fri, 11 Aug 2023 10:34:22 GMT

Hi,

it looks like it is not well formatted. you should firstly check the commas and parenthesis position.

Re: IF DAX code help

JamesMurg — Fri, 11 Aug 2023 10:37:23 GMT

Hi Fabrizio1
Could you help me put it in the correct format?

James

Re: IF DAX code help

Fabrizio1 — Fri, 11 Aug 2023 12:06:10 GMT

I guess you wanted to write a measure like this (even if I'm not sure that all the 4 ID described should be evaluated in an AND condition. Can they be all true at the same time?):

Column 2 =
IF(
AND(
'Report 1'[Destination ID]="IOMA",
'Report 1'[Destination ID]="IOMRT",
'Report 1'[Destination ID]="UK653",
'Report 1'[Destination ID]="IOM"),
"Isle of Man")

Re: IF DAX code help

mlsx4 — Fri, 11 Aug 2023 13:38:47 GMT

Hi JamesMurg

You haven't defined the correct structure for the formula. First of all, IF takes 3 parameters (condition, what you will do if condition is met, otherwise).
On the other hand, if you want to check if Destination ID is IOMA, IOMRT, UK653 or IOM you cannot use "AND", you should use "OR". Also, the formula cannot take more than two parameters, so you will need to use "||" operator.

Therefore you should have something like:

Column 2 = IF('Report 1'[Destination ID]="IOMA" ||'Report 1'[Destination ID]="IOMRT"|| 'Report 1'[Destination ID]="UK653"|| 'Report 1'[Destination ID]="IOM", "Isle of Man", <value in other case>)

Re: IF DAX code help

mlsx4 — Mon, 04 Sep 2023 06:56:40 GMT

JamesMurg

Have you checked this?