Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@channah1 Hi, you can create a calculate column using SWITCH function as below;
Please mark as soluntion if this helped.
@channah1 Hi, you can create a calculate column using SWITCH function as below;
Please mark as soluntion if this helped.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |