Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |