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 associated with them that determines the Points Scored, how do I do this so when select a Team it knows how many points is scored?

 

 

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

2 Replies

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