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

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
    Not applicable
    8 years ago

    Thanks Raj for the solution.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks AnonymousRaj for the solution.

  • ziyabikram96's avatar
    ziyabikram96
    Helper V
    6 years ago

    What if the DInOutdoor table is on the Many side? How to use RelatedTable then?