How to get DAX MIN (or MAX) value based on SORT BY COLUMN rule

[Anonymous]

Hi all,

Quite simple issue : I'm looking for a way to get MIN(columnA) knowing that column has been sorted by another columnB.

columnA data type = Text

Currently the MIN() function give me the minimum value with values beginning by "A"..

Thanks !

[v-jiascu-msft]

Hi @Anonymous,

What's the expected result? Maybe share a sample too.

Best Regards,
Dale

[Anonymous]

Here is a data table :

I sorted the column "Words" by the column "Order" :

I'd like to get in DAX : MIN(Words) = "What" instead of "A".

I wonder if the DAX logic could respect the sort order I set previously.

[AkhilAshok · Accepted solution]

Multiple ways to do this. Easiest way is to find the min order and get the Word for the min order:

Min Word =
VAR MinOrder =
    MIN ( 'Table'[Order] )
RETURN
    CALCULATE ( MIN ( 'Table'[Words] ), 'Table'[Order] = MinOrder )

[Anonymous]

Thanks !!