Kasper de Jonge PowerPivot Blog » Why SharePoint 2013 (ECS) is great for Multi dimensional!

One of the cool new features of Sharepoint 2013 is Excel Services with Field Lists.   Previously, design of a pivot table would need to be done prior to publishing to the server.   Now users have a way of designing self-service reports in the browser. 

Drag and drop, self service reporting is here.
Kasper de Jonge PowerPivot Blog » Why SharePoint 2013 (ECS) is great for Multi dimensional!

Frederik Vandeputte - Switch function Trick

=SWITCH(TRUE();
[Score] >=1 && [Score] <5; "C";
[Score] >= 5 && [Score] < 8; "B";
[Score] >=8 && [Score] <=10; "A";
"Wrong Value"
)

So SWITCH(TRUE();expression1; value1; expression2; value2; expression3; value3; .... ElseValue)  is the trick for rewriting nested IFs in DAX.

Frederik Vandeputte