SWITCH Function

[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

[MattAllington]

Sorry I didn't see this question earlier. There is no attachment in your post. But switch works like this