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.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks Raj for the solution.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks AnonymousRaj for the solution.