[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 674: file_get_contents(): http:// wrapper is disabled in the server configuration by allow_url_fopen=0
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 674: file_get_contents(http://powerpivotforum.com.au/dax-embed.php?formula=PXN3aXRjaCYjNDA7W3lvdXIgbWVhc3VyZV0sCiAgIDEsJnF1b3Q7QSZxdW90OywyLCZxdW90O0ImcXVvdDssMywmcXVvdDtDJnF1b3Q7JiM0MTs=): failed to open stream: no suitable wrapper could be found
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5313: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3925)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5313: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3925)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 5313: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3925)
PowerPivot Forum • SWITCH Function
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