Case statement to add extra column with custom data

Question

Need some help with building a case statement. My information brought back is telemetry based and need to adjust where a solution name is "Excel" I need it to rename it to "Microsoft Excel" (just an example). The coloumn with the data is called "Solution name".

Something in the line of Where solution name is "excel" then "MS excel"

Any help will be useful, thanks

Code below

let
    Source = Sql.Database("xx.xxx.xx.xx\Telemetry", "TELEMETRY"),
    dbo_Lookup_solutions = Source{[Schema="dbo",Item="Lookup_solutions"]}[Data]
in
    dbo_Lookup_solutions

Possible duplicate of [How do I use T-SQL's Case/When?](https://stackoverflow.com/questions/3342319/how-do-i-use-t-sqls-case-when) — Nope, Nov 17 '17 at 12:01

score 0 · Accepted Answer · answered Nov 17 '17 at 12:00

0

Case when solution like ‘%excel%’ then ‘msexcel’ else solution end

answered Nov 17 '17 at 12:00

Ab Bennett

1,391
17
24

Thanks mate - where in the entire code set would I add that? – Ettiene Vermeulen Nov 17 '17 at 12:04
Using it in Power BI. This is the standard returned code it gave me when I created the connection and view. – Ettiene Vermeulen Nov 17 '17 at 12:07
I’d create a view in the dataset using the case statement. Or if doing in power i this would be dax. Try https://community.powerbi.com/t5/Desktop/CASE-Statement-to-DAX/m-p/185578#M81585 – Ab Bennett Nov 17 '17 at 12:10

Case statement to add extra column with custom data

1 Answers1