Solved: Consulta de columna

jamieham · ‎08-20-2020

Quiero crear una nueva columna basada en una consulta de columna que use equipos Team y Home & Away para determinar si el equipo es Home o Away

Equipo	Equipo Local	Equipo de alejada	Inicio o lejos
Australia	Francia	Australia
Francia	Francia	Australia

FarhanAhmed · ‎08-20-2020

Cree una nueva columna en DAX mediante el uso de

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 , no ver borrar . Crear una nueva columna

si ([equipo] [Equipo local] ,"Inicio", "Distancia")

!! Power BI 101 Interview questions !! !! Master Microsoft Fabric- 36 Videos !!
Microsoft Power BI Learning Resources, 2023 !!
Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics !!
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Proud to be a Super User! !!

FarhanAhmed · ‎08-20-2020

Cree una nueva columna en DAX mediante el uso de

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 - Estoy pensando:

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

@ 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!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Consulta de columna

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024