Forum Discussion
heygowtam
Helper II
Helper IIGet a Second maximum value From COlumn
I have a Table of three Columns Date Season Bottles 14/12/2020 19 16 12/08/2020 19 21.4 11/06/2021 20 64 11/08/2021 21 51 5/11/2021 21 14 10/10/2022 22 15.3 ...
VahidDM
Super User
Super UserHi heygowtam
Use this DAX expression to find the Second Max date:
Second Max =
Var _Max = MAX( 'Table'[Date] )
return
CALCULATE(MAX( 'Table'[Date] ),REMOVEFILTERS('Table'),'Table'[Date]<_Max)
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
