If with multiple values

[nkasdali]

Hi all,

Please, can you help to write this on power bi ?

If(LOG_TD[AppId] in('WIREPORTSERVER';'WIREPORTSERVER.BIN';'BOE_CRPROCD.BIN';'BOE_JOBCD';'WEBIRICHCLIENT');'BO';Null)

Thanks

[Zubair_Muhammad · Accepted solution]

@nkasdali

Try this

New Column =
IF (
    LOG_TD[AppId]
        IN {
            "WIREPORTSERVER",
            "WIREPORTSERVER.BIN",
            "BOE_CRPROCD.BIN",
            "BOE_JOBCD",
            "WEBIRICHCLIENT" },
    "BO"
)