Forum Discussion
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
- Jihwan_Kim
Super User
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.
- elcapitanoRegular Visitor
Thank you so much - that worked really well!