Can I join a visual table that I created on a tab with an existing data table ?

[Anonymous]

Hi,

I created a visual table on a new page and would like to join with an existing data table.  Would like to join by "Vendor" if possible in Power BI.   Can this be done ?   Thanks for any help

Visual Table

Vendor                             No. of Contracts

ABC Company                             37

ACME Company                          45

XXX Company                             18

Existing table "Vendor Data"

Column:   Vendor

Column:  Address

Column:  Phone Number

[olgad]

Not sure what you mean, but you can use summarize/summarize columns to create a table like Summarize (exisistingTable, vendor, adress, phone, "no of contracts", measure to calculate those no of contracts)