Forum Discussion
Switch Max (tooltip) question
Hello:
I have made a tooltip and the dax code it works perfectly. Below is my code:
2021_Event_Type =
Switch(
Max('Table1'[WEEK]),
"1.6 W42", "Event1",
"1.7 W43", "Event2",
"2.8 W44", "Event3",
"2.8 W01", " ",
blank()
)
But now I want to add a condition week and FY = 2021
below is an incorrect code, but I want to do something like this:
2021_Event_Type =
Switch(
Max('Table1'[WEEK] & 'Table1'[FY] = 2021),
"1.6 W42", "Event1",
"1.7 W43", "Event2",
"2.8 W44", "Event3",
"2.8 W01", " ",
blank()
)
How can I do this?
samnaw , Try like
2021_Event_Type =
Switch(
Max('Table1'[WEEK]) && MAX('Table1'[FY]) = 2021,
"1.6 W42", "Event1",
"1.7 W43", "Event2",
"2.8 W44", "Event3",
"2.8 W01", " ",
blank()
)
2 Replies
samnaw , Try like
2021_Event_Type =
Switch(
Max('Table1'[WEEK]) && MAX('Table1'[FY]) = 2021,
"1.6 W42", "Event1",
"1.7 W43", "Event2",
"2.8 W44", "Event3",
"2.8 W01", " ",
blank()
)Hi samnaw , could you clarify your expected result more clearly?
In your Switch function, the Max('Table1'[WEEK] & 'Table1'[FY] = 2021) is used to compare with the values of "1.6 W42"/"1.7 W43"/... , but obviously they cannot be compared. What's the logic of the condition you want to realize? Will '2021' be involved in the values to be compared?
Best Regards,
Community Support Team _ Jing Zhang
