Forum Discussion

nkasdali's avatar
nkasdali
Microsoft Employee
8 years ago
Solved

If with multiple values

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
Tips and Tricks
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    nkasdali

     

    Try this

     

    New Column =
IF (
    LOG_TD[AppId]
        IN {
            "WIREPORTSERVER",
            "WIREPORTSERVER.BIN",
            "BOE_CRPROCD.BIN",
            "BOE_JOBCD",
            "WEBIRICHCLIENT" },
    "BO"
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

nkasdali

 

Try this

 

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