Hello I have posted this on Mr Excel, but as yet have not had a successful answer;
I want to get the Nth largest of smallest value using DAX , so in EXCEL you'd use LARGE or SMALL.
HTML Code:
the suggestion I had was to use TOPN and MIN or MAX, so to return the 3rd hight value
TOPN(3 , Table, Table[ Column Numbers ] )
to return a table containing the top 3 values. then wrap in MIN to get the lowest , 3rd.
I've tried variuos options none of which has worked,
Please Login or Register to view this content.
etc.Please Login or Register to view this content.
Does anyone have any suggestions?
Richard.
Bookmarks