MAX VALUE IN A ROW

Hello there Anonymous ! To get your desire result, I would recommend the following:

1. Go to PQ, and select your "busnumber" and "SEATINGCAPACITY" columns and unpivot the other columns. You then get a "Attribute" and a "Value" column where your Attribute becomes the "Day" and the Value becomes the seatings (I suppose)

2. Close and Apply PQ

3. Add the following measure 

Max Value =
CALCULATE (
    SELECTEDVALUE ( Table[busnumber] ),
    FILTER ( Table, [Value] = MAX ( Table[Value] ) )
)

4. Add the measure to your table visual and check the results.

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes

You can use following formula to get Max in PQ

=List.Max({[Sunday],[Monday],[Tuesday]})

Hi Vijay,

Thanks a lot

👍

Hi Goncalogeraldes,

Thank you so much 

👍