Measure issue - question

[channah1]

Hi,

I am attempting to create a new method of tracking qualifications.

The data is in the format below

Employee Name // Equipment // Qualification

There are around 50 pieces of equipment

There is 3 levels of qualification for each piece of equipment (Basic, Intermediate & Advanced)

Each Qualification is put in as a new line item. So someone who is advanced at a certain piece of equipment will have 3 line items for one piece equipment. Someone who is intermediate will only have two.

The main issue I am having is that a lot of the qualification names have changed over the years e.g. BASIC for a specific piece of equipment can have 8 different names but all represent the same qualification.

Would a measure or column like the following be possible?

IF(qualification column) = (Basic Option 1,Basic Option 2,Basic Option3…) = basic OR IF(qualification column) = (Intermediate Option 1, Intermediate Option 2, Intermediate Option 3….) = Intermediate OR IF(qualification column) = (advanced Option 1, advanced option 2, advanced option 3…) = advanced OR IF(qualification column) ≠ (Basic Option 1,Basic Option 2,Basic Option3… + Intermediate Option 1, Intermediate Option 2, Intermediate Option 3…. + advanced Option 1, advanced option 2, advanced option 3…) = NA

If it is possible would someone be able to help with an example format or how to input the coding? 

Thank you for your time. 

CH

Thanks for your help. 

[colacan · Accepted solution]

@channah1  Hi, you can create a calculate column using SWITCH function as below;

Equipment2 =

SWITCH(TRUE,

Yourtable[Equipment] in {"BasicOption1","BasicOption2","BasicOption3"}, "Basic",

Yourtable[Equipment] in {"InterOption1","InterOption2","InterOption3"}, "Intermediate",

Yourtable[Equipment] in {"AdvanOption1","AdvanOption2","AdvanOption3"}, "Advanced")

Please mark as soluntion if this helped.