Forum Discussion
Multiple IF statements inside switch case
Hi Anonymous
the first part has random non-DAX code like "starts with". For the secodn part, you'd need something like this. You'll probably have to adapt it a bit but you'll get the idea.
Category = VAR cat_raw = 'Data'[Category_Raw] VAR new = SWITCH ( TRUE (), AND ( 'Data'[Facility] = "BC", OR ( 'Data'[Type] = "YYYY", 'Data'[Type] = "YXYX" ) ), "YContainer", AND ( 'Data'[Facility] = "CD", 'Data'[Type] = "CDCD" ), "DContainer", cat_raw ) RETURN newLook at the syntax of SWITCH to understand well how it works
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi Anonymous
the first part has random non-DAX code like "starts with". For the secodn part, you'd need something like this. You'll probably have to adapt it a bit but you'll get the idea.
Category =
VAR cat_raw = 'Data'[Category_Raw]
VAR new =
SWITCH (
TRUE (),
AND (
'Data'[Facility] = "BC",
OR ( 'Data'[Type] = "YYYY", 'Data'[Type] = "YXYX" )
), "YContainer",
AND ( 'Data'[Facility] = "CD", 'Data'[Type] = "CDCD" ), "DContainer",
cat_raw
)
RETURN
newLook at the syntax of SWITCH to understand well how it works
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Sorry about the non dax part, it was for my understanding which i will do it later , to search and to use contain in dax query .So for the time being i am using "=" only , and i also tried removing the IF statements and i am still getting the same error