Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need Help on Multiple Logic

I am trying to replicate this to PowerBI

using this

But it doesn't work. 
I also tried using switch. 



  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Try this:

    IF([via] in values("aaa","bbb","ccc") && [sta] in values("aaa","bbb","ccc"),"sc","dc")

     

    Best Regards,

    Jay

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    Try this:

    IF([via] in values("aaa","bbb","ccc") && [sta] in values("aaa","bbb","ccc"),"sc","dc")

     

    Best Regards,

    Jay