Top 5 Values From Multiple Columns

[buckeye]

Hi! All,

I am looking for a way to retrieve the top 5 highest values out of 3 seperate columns. I am not looking for the top 5 of each column but the top 5 of all columns put together. Any help on this would be greatly appreciated.

Thanks 

[Greg_Deckler · Accepted solution]

Given this:

Column1	Column2	Column3
100	500	600
200	3	1
1	4	2
2	5	3
3	6	4

Use this:

Measure = 
VAR tmpTable = UNION(UNION(VALUES(Table[Column1]),VALUES(Table[Column2])),VALUES(Table[Column3]))
RETURN CONCATENATEX(TOPN(5,tmpTable,[Column1],DESC),[Column1],",")

End up with this:

6,100,500,600,200

[buckeye]

Thanks Greg for the help. 

Any thoughts on how I could pull the date from another column to match up with each value ?