get min of allselected except

[lpd82]

I have a column list of dates, how do I get the minimum date SELECTED date while ignoring one specific value?

For example: I want to get the value of 23/03/17 from the selected values ignoring 00/01/01.

Thanks in advance!

[tamerj1 · Accepted solution]

Hi @lpd82 

please try

=
MAXX ( TOPN ( 2, ALLSELECTED ( 'Table'[Date] ), 'Table'[Date] ), 'Table'[Date] )