Column Query

[jamieham]

I want to create a new column based on a column query that uses Team  and Home & Away teams to determine if the Team is Home or Away

Team	Home Team	Away Team	Home or Away
Australia	France	Australia
France	France	Australia

[amitchandak]

@jamieham , not ver clear . Create a new column

if ([team]=[Home Team] ,"Home", "Away")

[FarhanAhmed · Accepted solution]

Create a new column in DAX by using

NewColumn = IF (Table[Team]=Table[Home Team],"Home","Away")

[Greg_Deckler]

@jamieham - I'm thinking:

Home or Away =
  IF([Team] = [Home Team],"Home","Away")