Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SWITCH or IF in calculated columns

Hi,  I want to create a calculated column named Category from  two tables DWSP  DInOutdoor   DWSP table has column named WSP  DInOutdoor has column named InOutdoor   Following is the conditio...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous

     

    You need to use SWITCH().

     

    New col = 
VAR  vInOut = RELATED(DInOutdoor[InOutdoor])
RETURN
SWITCH ( TRUE(),
          Dwsp[Wsp]= "STG".Strategic,
         vInOut = "Indoor","Indoor",
         vInout= "Outdoor","Outdoor",
         "Unknown")

     

    Thanks

    Raj

  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks AnonymousRaj for the solution.

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous,

 

In which table you need to create such a calculated column? Is there any relationship between these two tables? Please provide dummy data to illustrate your scenario.

 

Regards,

Yuliana Gu