Converting test scores to letter grades in power BI

[eugeneleefl]

I am currently using Power BI for educational statistics. Basically, I have a table of numeric scores (e.g. 30, 40.5, 60, 99.4 etc) and I wish to add a new column in the Query Editor to convert these numbers into letter grades with the following rules:

A: 70 to 100

B: 65 to 69

C: 60 to 64

😧 55 to 59

E: 50 to 54

F: 49 and below

Is there a efficient way to do this as I have multiple columns to convert? Thanks. 

[v-caliao-msft · Accepted solution]

@eugeneleefl,

There is no SWITCH function in Power Query, so the easiest way to do this is create calculated column by using DAX.
Column =
var xx = Table1[Amout]
return SWITCH(TRUE(),xx>=70&&xx<=100,"A"
,xx>=65&&xx<=69,"B"
,xx>=60&&xx<=64,"C"
,xx>=55&&xx<=59,"D"
,xx>=50&&xx<=54,"E"
,xx<=49,"F")

Regards,

Charlie Liao