March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi all,
I am running a skill matrix on my team and in few questions we are asking them to give themself a score on few categories. For instance in Excecel they can select between 5 options: Novice, Understand basics, Capable, Advance, Expert.
Now these words will appear on many columns at a row level. I wouldn't like to create a custom column cause it would take me a lot of time cause i would need to create as many custom columns as many questions I have. What i would like to do is set up some rules and assign a numeric value to each option such as: Novice = 1; Understand basics = 2; and so on.
Does anyone knows how i can achieve this?
Thanks in advance,
Solved! Go to Solution.
Since, there are many columns which you need to make this replacement and you don't want to create new columns, I would suggest you should do this in Power Query which will do the replacement within the columns themselves
Select all columns which are for questions
Transform - Replace values - Replace Novice with 1. Do the same for other words as well with their respective values as well.
Hello @amitchandak,
How can I do the same with a measurement instead of creating a new column, when Swicth is asking me for an expresion over this text column
Regards
Since, there are many columns which you need to make this replacement and you don't want to create new columns, I would suggest you should do this in Power Query which will do the replacement within the columns themselves
Select all columns which are for questions
Transform - Replace values - Replace Novice with 1. Do the same for other words as well with their respective values as well.
@Alessandro-laba , Based on what I got
A new column
Switch( Table[Column],
"Novice" , 1,
"Understand basics", 2,
// Add other values
)
If there are circular dependencies then create a new column
column1 =[Column]
Then the set other column as the sort column
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
94 | |
89 | |
86 | |
77 | |
49 |
User | Count |
---|---|
164 | |
149 | |
101 | |
73 | |
56 |