SWITCH or IF in calculated columns

[kan]

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 condition I need to implement.

If WSP = ‘STG’ then ‘Strategic’

Else if InOutdoor = ‘Indoor’ then ‘Indoor’

Else if InOutdoor = ‘Oudoor’ then ‘Oudoor’

Else ‘Unknown’

I know how to use switch with single table.Can someone help me how to write above condition when using tables.

Thanks..

[Anonymous · Accepted solution]

Hi @kan

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

[v-yulgu-msft]

Hi @kan,

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

[Anonymous · Accepted solution]

Hi @kan

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

[ziyabikram96]

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

[kan]

Thanks Raj for the solution.

[kan · Accepted solution]

Thanks @AnonymousRaj for the solution.