Want to make the amount of data equal

[Anonymous]

I Merged 2 tables together using Equipment columns as Key but because the amount of data is not the same. Therefore, the information that is displayed Visualization not as desired.

I would like to know any way. That makes the data amount 15463 of 15463 rows.

As shown in the illustration, the amount of data is 6759 of 15463 rows.

Please help me in the process. Thank you in advance.

[Anonymous]

Hi @Anonymous ,

We assume that [Device] is unique as a key in Tables 1 and 2. I get the information that Table1 has 15463 records and Table2 has 6759 records. When a Left out join merge query is performed using Table 1 as the primary table, all 15463 rows of Table 1 are returned(Is this what you expected? It will keep all the records in Table1.), and null is returned if no matches are found.

The general behavior can be summarized in the following picture:

Left outer join

All join kind:

Merge queries overview

If this doesn't solve your question, please feel free to contact us.
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[Syndicate_Admin]

Duplicate 32 DT, HD, and SCSI drives with 4 IDE gadgets. Likewise, Join the virtual development and set up a confounded imitating choice. Emulate the most common way of consuming a plate with a virtual burner.

[adudani]

HI @Anonymous ,

It seems to me that the Equipment column is text.

If it is all numbers, conver it to whole number and see if it matches.

If text is the data type you'd like to merge, try transforming the colum with trim, clean and upper. That should handle case sensitivity, unless there are delimeters.

Other alternative depending on the type of data are:

1. To handle case sensitivity better Ignoring Case Sensitivity in Power Query - YouTube

Or,

2. Fuzzing matching or creating a transformation table:

(33) Fuzzy match / merging in Power BI Desktop (October 2018) - YouTube