Forum Discussion
Resolver IJoining Tables
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
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)
Regards,
Xiaoxin Sheng
Resolver IHi,
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