SWITCH Function

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

SWITCH Function

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


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?
Capture d’écran 2017-05-21 à 23.34.39.png

Posts: 999
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 Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

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

Who is online

Users browsing this forum: No registered users and 1 guest