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 ...
Need Help
Tips and Tricks
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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.

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

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
    3 years ago

    Thank you so much - that worked really well!