Forum Discussion

jamieham's avatar
jamieham
Helper II
5 years ago
Solved

DAX Query

I have a table with the fields listed below and I want to create a column that shows the Points Scored (in Red) by a Team. A fixture will have a Home Team and Away Team and both have a score associat...
Need Help
  • VijayP's avatar
    VijayP
    5 years ago

    jamieham 
    =IF(Team=AwayTeam,Away Team score,homeTeamScore)

     

    Hope this will help you. if this is the solution then please mark this as solution and share your Kudoes

    Vijay Perepa

VijayP's avatar
VijayP
Community Champion
5 years ago

jamieham 
=IF(Team=AwayTeam,Away Team score,homeTeamScore)

 

Hope this will help you. if this is the solution then please mark this as solution and share your Kudoes

Vijay Perepa

VijayP's avatar
VijayP
Community Champion
5 years ago

jamieham 

Thanks! Please Share your Valuable Kudoes as well. Just a click on Thumps up icon near my Post ! Thanks again!