SQL CODE

[AKARSEVGI]

(CASE WHEN UO.SALDEPTGRP IN 'SSH' THEN 'ASS'
WHEN UO.SALDEPTGRP = 'ENDÜSTRİ-GIDA' THEN 'INDUSTRY-FOOD'
WHEN UO.SALDEPTGRP = 'ÇEVRE-ENERJİ' THEN 'ENVIRONMENT-ENERGY'
WHEN UO.SALDEPTGRP = 'ZEYTİNYAĞI' THEN 'OLIVE OIL' END) AS SALDEPTEGRP,

Why doesn't work it in power bi? I mean I couldn't see INDUSTRY-FOOD, ENVIRONMENT-ENERGY,OLIVE OIL in the columns which SALDEPTEGRP topic.

[AKARSEVGI]

No, I want to fix it in power query? How can I?

[amitchandak · Accepted solution]

@AKARSEVGI , Power BI Dax you have to use switch

Switch( True() ,

UO.SALDEPTGRP= "SSH" , "ASS"
,UO.SALDEPTGRP = "ENDÜSTRİ-GIDA" THEN "INDUSTRY-FOOD"
,UO.SALDEPTGRP = "ÇEVRE-ENERJİ" THEN "ENVIRONMENT-ENERGY")

Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56

WHEN UO.SALDEPTGRP = 'ZEYTİNYAĞI' THEN 'OLIVE OIL' END) AS SALDEPTEGRP,