Dublicated/Referenced query produce table with different number of rows

[Caspe1010]

Hi there! 

In Power Query Editor I have tried both to dublicate and reference a query in order to produce a new but identical table to work with in the Report view. However, I experience that the new table contains a different amount of rows than the table generated from the original query. 

I have not been able to figure out why. Hope someone can help me understand this 

Best regards

[Idrissshatila]

Hello @Caspe1010 ,

in the transform tab under the statistics, try to do this count in both just to double check

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Caspe1010]

Hi @Idrissshatila 

I get the following results when doing the counts.

	Original Query	Referenced Query
Count Value	2998	2998
Count distinct values	2644	2644

I assume the difference arise because I apply the counted value in one table and the distinct counted value in the other. Could that be true? And if so, how do I make sure to apply the same count in both? 

Thanks!

[Idrissshatila]

Hello @Caspe1010 ,

I didn't understand the question, but the numbers looks the same then the tables are the same.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Caspe1010]

Thank you @Idrissshatila