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

1 Reply

  • 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"
)