xjiang Tracker

Re: Issue with using information from both tables after creating relationship

xjiang — Thu, 04 Oct 2018 21:54:48 GMT

Hi David,

Thanks again!

Will this solution work if the 2 tables don't have the same number of rows? The actual stats table didn't included the plans in table A that got cancelled.

Thanks,

Re: Issue with using information from both tables after creating relationship

xjiang — Thu, 04 Oct 2018 21:19:37 GMT

Hi,

Thanks for your response!

Both of my tables are from SQL server and I don't have permission to create an extra index column in SQL. There's no single column that is unique enough for me to merge them together.

Is it possible to create an extra index column using the combination of existing columns in power bi query editor?

Issue with using information from both tables after creating relationship

xjiang — Thu, 04 Oct 2018 21:03:05 GMT

Hello all,

I need some help for a project that I have been working on,

I have 2 tables (A: 40 columns with the planning stats) (B: 48 columns with the actual stats). Each table has more than 1 millon rows.

I used 7 columns that exist in both tables and created a unique index for each row. I then successfully created a relationship between these two tables: cardinality: 1:1, cross filter direction: both.

However, I started to have issues while I use those tables together.

Here is an example:

I used origination and destination from table A, and want to use the average of minutes from table B, but Power BI won't show the results. When I added this column from table B, the origination and destination from table A just disappeared from the visual.

In table B, origination and destination is named as Org and Des, will that be the problem? Both columns in both tables are in text format. The issue is not only with these two columns. even date from table A won't have the correct corresponding information from table B.

Can someone help me on this issue? Thanks a lot!!