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, Is there a way where I can combine distinct values of mutiple columns within the same table and display them in one single column.
For example I have Table A with columns X,Y,Z and all 3 columns have multiple values as shown below.
X Y Z
aa ee dd
bb rrr qq
ff aa rrr
The output of the DAX should be
Outputcolumn
aa
bb
ff
ee
rrr
dd
Order of the values doesn't matter.
Thanks for your time.
Solved! Go to Solution.
@Anonymous , Try a new table like
distinct(union(all(Table[X]),all(Table[Y]),all(Table[Z])))
@Anonymous , Try a new table like
distinct(union(all(Table[X]),all(Table[Y]),all(Table[Z])))
Hi,
In the Query Editor this should be easy to do. Insert an Index column. Select that column and "Univot other columns". Remove all columns except the Value column. Remove duplicates from the Value column.
Hope this helps.
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |