DAX Script

[jamieham]

Hi

I want to add a new column that details a result from rugby scores that lists the outcome as Won, Lost or Drawn.

My data looks like the table below but I have no idea how to do it.

Game ID     Team              Home Team       Away Team     Home Team Score      Away Team Score     Result

1                 England           England              Wales                     25                                 16                     Won

1                 Wales              England              Wales                     16                                25                     Lost

2                 Scotland          Ireland              Scotland                   32                               32                    Draw

2                 Ireland             Ireland              Scotland                   32                               32                    Draw

Any help would be appreciated.

Thanks

[v-henryk-mstf · Accepted solution]

Hi @jamieham ,

According to your needs, you can try to create a measure and use nested IF function as the judgment condition. I have tried the following as a reference:

If the problem is still not resolved, please provide detailed error information and let me know immediately, looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jamieham , Create a new column like

Switch( true(),
[Home Team Score] = [Away Team Score] , "Draw",
[Home Team Score] > [Away Team Score] , "Won",
"Lost"
)