SWITCH Function

A dedicated forum to help people when working through the book "Learn to Write DAX"
mabast79
Posts: 1
Joined: Mon May 22, 2017 9:21 am

SWITCH Function

Postby mabast79 » Mon May 22, 2017 9:46 am

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
Posts: 873
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: SWITCH Function

Postby MattAllington » Sun Jun 04, 2017 7:53 pm

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

Matt Allington is Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax


Return to “Help with the Book "Learn to Write DAX"”

Who is online

Users browsing this forum: No registered users and 1 guest