Get a Second maximum value From COlumn

[heygowtam]

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

1) Sum the Bottle quantity by Season number then 

2) I need to Find the Difference From

---Calculate(SUM[Bottles]  WHERE  season = MAX[season]  - SUM[Bottles ] WHERE season =  SECONDMAX [season])

My question is

If i want Selelct Maximum Value - Max[season],

How can i select  second MAX value 

[Ashish_Mathur]

Hi,

Please show the expected result clearly.

[VahidDM]

Hi @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!! 

LinkedIn | Twitter | Blog | YouTube 

[heygowtam]

@VahidDM 
Thanks for your Reply, 

I need to pick second highest Season value, 
then subtract from first maximum [Season ] Value,