Forum Discussion

channah1's avatar
channah1
New Member
4 years ago
Solved

Measure issue - question

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 T...
  • colacan's avatar
    colacan
    4 years ago

    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.

colacan's avatar
colacan
Resolver II
4 years ago

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.