Solved: Re: Column Query

jamieham · ‎08-20-2020

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

FarhanAhmed · ‎08-20-2020

Create a new column in DAX by using

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!

View solution in original post

amitchandak · ‎08-20-2020

@jamieham , not ver clear . Create a new column

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

FarhanAhmed · ‎08-20-2020

Create a new column in DAX by using

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!

Greg_Deckler · ‎08-20-2020

@jamieham - I'm thinking:

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...