Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I have 2 tables of the same columns and column names. Individually, they have distinct values for a certain ID column.
When I join the 2 tables via
UNION(EqmtDT, EqmtDT_H)
, the ID column now shows no distinct values. Why did this happen?
I figured out my problem. I did have dupes in the separate tables.
Hi, can you share pbix file?
--
PC
Hi @Anonymous
Your tables might have IDs in commun thats why the distinct count of IDs does not eq to total rows.
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
There are none in common, I exported to excel and checked for duplicates and there were none.
Could you share the pbix file?
Did it work ? 👌 Mark it as a solution to help spreading knowledge 👉 A kudos would be appreciated
User | Count |
---|---|
141 | |
71 | |
70 | |
54 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |