Calculated Column: Highest Score Flag

[pvans267]

Good evening,

I hope someone can help me. I am very new to Power BI and am busy building an app to analyse the results of my wife and my board game results.

Game ID	Player	Military	Science	Total
1	Paul	32	76	108
1	Sarah	12	35	47
2	Paul	15	25	40
2	Sarah	27	56	83
3	Paul	44	24	68
3	Sarah	22	21	43
3	Joe	15	26	41

I would like to create a calculated columns that flags for each game, who won:
Military,
Science,
Total

I can do it in Excel using VBA, but would prefer to use the Query Editor in Power BI if possible.

Please can someone help me?

Thank you