DAX If(or(mid with three conditions

[millardpsmith]

Hi there,

I’m working on converting a number of Excel spreadsheets to Power BI.

In excel multiple IF(OR(MID conditions are straight forward:
=IF(OR(MID(G2,10,1)="1",MID(G2,10,1)="2",MID(G2,10,1)="3"),”XXXX",N2)

In DAX this isn’t as easy:

I’m adding a column in the dashboard and what I’m looking for is an IF(OR(MID with three conditions, using the same Column in the MID.

Here is essentially what I would like:

NEW COLUMN NAME = IF(OR(MID(‘EXISTING-COLUMN-NAME’,10,1) = “1”, MID(‘EXISTING-COLUMN-NAME’,10,1) = “2”, MID(‘EXISTING-COLUMN-NAME’,10,1) = “3”, “XXXX”, ‘ANOTHER-CUSTOM-COLUMN’)

Thanks

[millardpsmith]

Thank you, worked first try.

[AlB]

Hi @millardpsmith

Try this, where both items highlighted in red need to be a string or a reference to a string

NEW COLUMN NAME =
IF (
    MID ( 'EXISTING-COLUMN-NAME', 10, 1 ) = { "1", "2", "3" },
    "XXXX",
    'ANOTHER-CUSTOM-COLUMN'
)

[Greg_Deckler · Accepted solution]

Should be:

NEW COLUMN NAME = IF(OR(OR(MID(‘EXISTING-COLUMN-NAME’,10,1) = “1”, MID(‘EXISTING-COLUMN-NAME’,10,1) = “2”), MID(‘EXISTING-COLUMN-NAME’,10,1) = “3”), “XXXX”, ‘ANOTHER-CUSTOM-COLUMN’)