topic Switch Case for Every Column Value in DAX Commands and Tips

Switch Case for Every Column Value

Anonymous — Wed, 12 Feb 2020 04:54:00 GMT

Hey Guys,
I need some urgent help here.So i have the data as in mentioned format below :

Questions	Category
Question 1	A
Question 2	B
Question 3	C
Question 4	A
Question 5	B
Question 6	C

So i have different questions which are categorized.I have already created measures for different questions and categories and i am using below code to show it in a table

Switch_CXI_Questions = SWITCH(MAX(Table1[Category]),"Question1",[Average question1], "Question2",[Average question2],.....,"Question6",[Average Question 6])

Re: Switch Case for Every Column Value

sturlaws — Mon, 24 Feb 2020 11:54:02 GMT

Hi Anonymous

is there a question here?

Cheers,
Sturla

Re: Switch Case for Every Column Value

Pragati11 — Mon, 24 Feb 2020 17:35:02 GMT

Hi Anonymous ,

Did you miss the question here? 😛

Thanks,

Pragati

Re: Switch Case for Every Column Value

Anonymous — Mon, 24 Feb 2020 17:54:27 GMT

The answer is... It's wrong. Simply.

Best
D