Page 1 of 1

SWITCH Function

Posted: Mon May 22, 2017 9:46 am
by mabast79
hi,

I am trying to test SWITCH function in my excel 2016 version.
In the attached file you can find, I want to know how to give value to ID matière like this :
A goes with 1
B goes with 2 and
C goes with 3

Like you can see in the screenshot, I get a red value for the letter A.
could you help me please?
DAX.xlsx
Capture d’écran 2017-05-21 à 23.34.39.png

Re: SWITCH Function

Posted: Sun Jun 04, 2017 7:53 pm
by MattAllington
Sorry I didn't see this question earlier. There is no attachment in your post. But switch works like this