Max Value with its Attribute, Month and Lane

[ParsiNitin]

Hello,

I have a small problem. I have used MAX measure to get the max valur from the column Value but at the same time I need where did it come from for example if the higesht value is from Attribute 2022 (----) with Land H S I want to get that information as well. can anyone suggest me a code for this please?

So here the Max value is 4353 so it shoudl represent Value as 4353 and July with 2022 (------){Attribute} and Leix------ {Lane}

[Shishir22]

Hello @ParsiNitin ,

Can you please send data in tabular format with expected result in tabular format instead of picture?

[ParsiNitin]

Hi @Shishir22 Sorry that i cant send in the form you asked as its companys data I should rewrite with different dummy names and i should send it. 

[ParsiNitin]

Hello @Shishir22 

Here the max value for all the lanes (25 different) with 2022,23,24&25 as years. So here it is showing the value which is correct but I want to see from which lane it is coming from and which Year and which month as well.