Power bi DAX

[BIswajit_Das]

Table

AC_NO	B	I	J	O
25	29.29	47.43	0.46	0
30	51.47	46.97	0.25	0
31	26.68	43.75	18.9	0
35	17.66	42.3	36.16	0
36	42.57	54.72	0.74	0

how to get 2nd largest value from B,I,J,O

I.E for 25 it's 29.29

for 30 it's 46.97

[BIswajit_Das]

This really is helpfull
Thanks

[Ahmedx · Accepted solution]

pls try this

Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26RiC64UVp13BOaMln5?e=0ryl3l