Conditional kolomn in query editor

[Vosjeee7502]

Dear, 

I have an issue where we work with a lot of different zone types. Now i want to narrow these down to just 3 option so i think i have to add an extra colomn in the query editor. However i have no experience with the DAX formula's etc. 

The 2 options are "Koel/vries" and "Ambient"

The following zones should all result in the kolomn calculating "Koel/vries":

+2°C +8°C

-20°C -25°C

-35°C -45°C

-65°C -85°C

-70°C -90°C

BHSC

BHSDGC

Bonded Cool

BRICS

CD2 +2°C +8°C

COOL_AND_FREEZE

CY +2°C +8°C

DG1 +2°C +8°C

DG1 -65°C -85°C

DG3 +2°C +8°C

HS +2°C +8°C

KROON_ZONE

The following zones should all result in the kolomn calculating "Ambient":

+15°C +25°C

BHSA

Bonded Ambient

BONDED_AND_AMBIENT

CD +15°C +25°C

CY +15°C +25°C

DG1 +15°C +25°C

DG2 +15°C +25°C

DG3 +15°C +25°C

HI +15°C +25°C

HS +15°C +25°C

Everything else should result in "onbekend"

Hopefully you can help

BR Kevin

[ray_aramburo · Accepted solution]

Are the zones text strings?