I Have Two tablesand i need to link these two tables with two Columns

[manojgl]

Hi ,

I have Two Tables  in powerBI destop , and i created one Tab with these two tables now i need to have relations between these two tables by Brand (Tags) and Date . so that all charts in tab has filtering capabilities. please help to resolve this.

Thanks ,

[v-caliao-msft]

@manojgl,

Could you please share  some sample data for us.

Power BI Desktop makes creating those relationships easy. In-fact, in most cases you won’t have to do anything, the Autodetect feature can do it for you.

In some cases you might have to create relationships yourself, or you might need to make some changes to a relationship.

Regards,

Charlie Liao

[manojgl · Accepted solution]

We able to create look up tables by creating seperate Key and problem solved thanks for your response

[Greg_Deckler]

CONCATENATE the fields in a new column?