Tableau to DAX

[Anonymous]

Done

[Hariharan_R · Accepted solution]

Hi,

Use the below expression. The value of Left or Remained is considered a number. 

Result =
SWITCH (
    'Table'[Left or Remained],
    1, 'Table'[Resident - Left Housing],
    2, "FALSE"
)

Result =
SWITCH (
TRUE (),
Eth[Ethnicity] IN { "A", "B", "H", "I", "M", "P" }, "ALANA",
Eth[Ethnicity] = "N", "International",
Eth[Ethnicity] = "C", "White",
"Unknown"
)

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin