Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have table as source for my report where data values are coming in from 17 different columns
e.g.
employee # Level_1_User Level_2_User Level_3_User Level_4_User
N000789 N000123 N000234 N000345 N000456
N000147 N000123 N000234 N000876
N000852 N000123 N000963 N000632 N000888
For above example I wanted to create a single column that sources values from Level_1_User, Level_2_User,Level_3_User,Level_4_User and generates the distinct list of values as result column.
Solved! Go to Solution.
Hi, In Query Editor you can Select Employee# column and unpivot other columns. After that select the column and Remove Duplicates (In Transform Menu)
Regards
Victor
Lima - Peru
Hi, In Query Editor you can Select Employee# column and unpivot other columns. After that select the column and Remove Duplicates (In Transform Menu)
Regards
Victor
Lima - Peru
User | Count |
---|---|
131 | |
71 | |
70 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |