Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Syndicate_Admin
Administrator
Administrator

Una tabla que tiene valores de la tabla1 y todos los valores de la tabla2 que no están relacionados.

Tengo dos tablas de la siguiente manera:
Cust

costarSuppo
7a
7b
8a


Supp

Suppo
a
b
c


Quiero que el objeto visual de tabla/matriz sea el siguiente:
t1 =

costarSuppo
7a
7b
8a


t2 =

costarSuppo
7c
8b
8c

Ambas tablas están relacionadas por la columna suppo. ¿Cómo puedo crear un objeto visual t2?

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

Consulta T2:

let
    Source = Table.SelectColumns(t1,{"custo"}),
    #"Removed Duplicates" = Table.Distinct(Source),
    #"Added Custom" = Table.AddColumn(#"Removed Duplicates", "Custom", each Supp),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Suppo"}, {"Suppo"}),
    #"Merged Queries" = Table.NestedJoin(#"Expanded Custom", {"custo", "Suppo"}, t1, {"custo", "suppo"}, "t1", JoinKind.LeftAnti),
    #"Removed Other Columns" = Table.SelectColumns(#"Merged Queries",{"custo", "Suppo"})
in
    #"Removed Other Columns"

Helpful resources

Announcements
FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.