A table which has values from table1 and all values from table2 which are not related.

[Anonymous]

I have two tables as below:
Cust

custo	suppo
7	a
7	b
8	a

Supp

Suppo

a

b

c

I want to table/matrix visual as follows:
t1 = 

custo	suppo
7	a
7	b
8	a

t2 = 

custo	suppo
7	c
8	b
8	c

both tables are related by suppo column. How do i create t2 visual?

[lbendlin]

In Power Query this would be the approach

t2  query:

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"

in DAX it's easier as you can use EXCEPT

t2_DAX = except(crossjoin(values(t1[custo]),values(Supp[Suppo])),t1)