Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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", "Eve...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , 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()
    )

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous , 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