Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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