Forum Discussion

elcapitano's avatar
elcapitano
Regular Visitor
3 years ago
Solved

Calculating Win/Loss results

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

 

  • 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.

     

2 Replies

  • 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's avatar
      elcapitano
      Regular Visitor

      Thank you so much - that worked really well!