Forum Discussion
Tableau to DAX
Done
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
1 Reply
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