Return top value ordered by another column

Another way to do this is through the use of the TOPN function. The TOPN function returns entire row(s) instead of a single value. For example, the code TOPN(1, TableA, TableA[Value]) returns the top 1 row of TableA ordered by TableA[Value]. The Group value associated with that top Value is in the row, but we … Read more