Joining Tables

[Boycie92]

Hi

I am wondering if someone can help,

I have a table that has Product ID 1 and Product ID 2 (they both link to the same product)

I have a also have a Date Table.

I want to be able to merge them together so that every date within the date table has Product ID 1 & 2 beside them

Is this possible?

Thanks in advance,

Boycie92

[v-shex-msft]

Hi @Boycie92,

You can try to use table.join function(power query) to deal with these data.

Sample:

Combine data from multiple data sources (Power Query)

Merge Tables in Power Query

Regards,

Xiaoxin Sheng

[Boycie92 · Accepted solution]

Hi,

Sorry for the delay,

This post was based on a solution I was trying to create based on this query: http://community.powerbi.com/t5/Desktop/Time-intelligence-Data-Modeling-Issue/m-p/274418#M122663

I thought the best way to solve my issue was to have my Unique ID’s be attached to my date table.

Essentially I was having an issue linking my data using both the Unique ID’s and the Dates.

At the time I could get my sources to link using dates and I would get the correct results at the high level but when I wanted to drill down I got incorrect results. This was because at the time I couldn’t establish a relationship with my unique ID’s and Dates at the same time.

I have since realised that my question was not the correct way to handle the problem.

Thank you to those that responded.

Boycie92