Second Highest number in MAX function using DAX

Question

I have a variable as below VAR First_Higest_number = MAX( 'DF'[Number_Column] ) and I would like to find the Second_Higest_numberin DAX. How to get around with this ? many thanks in advance.

Answer 1

You might use the search first, as it seems to be a duplication
VAR Second_Higest_number = MINX ( TOPN ( 2, 'DF', 'DF'[Number_Column] ), 'DF'[Number_Column] )