Calculating Win/Loss results

[elcapitano]

Hi everyone, 

Hoping to get some help with calculating a new column to denote which team won the game. The data I've loaded in the attached PBI looks as follows

I want to generate a new column called Result that would show a 1 for the team that won the game and blank (or 0) for the team that lost. E.g. the outcome for the above 3 games should be

I've created a sample PBI file with the above data here https://drive.google.com/file/d/12QO1l0U3Pk98l0kXeWSVI2ckJCz3benp/view?usp=sharing

Is there a neat way to do this with Power Query or would it have to be a calculated column?

Thank you in advance for any help you can provide.

cheers

Mark

[Jihwan_Kim · Accepted solution]

Hi,

I tried to create the solution in Power Query Editor.

One of ways is to create a group table that shows win information and then merge it.

Please check the attached file.

[elcapitano]

Thank you so much - that worked really well!