Forum Discussion
Solved
Top 5 Values From Multiple Columns
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
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
2 Replies
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
Thanks Greg for the help.
Any thoughts on how I could pull the date from another column to match up with each value ?
