Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
8 years ago
Solved

Joining Tables

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

Need Help
Show and Tell
  • Boycie92's avatar
    Boycie92
    8 years ago

    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

     

2 Replies

    • Boycie92's avatar
      Boycie92
      Resolver I
      8 years ago

      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