Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
OC101
Frequent Visitor

How to find new (different) items from two columns in different tables?

Hi,

I am kind of new in Power BI, I have below question, could you please help?

There are Table 1 and Table 2.  Table 1 is the first test, and many parts are taken out after the first test, Table 2 is the 2nd test and some new parts were added in the test. Now I need to find out which parts are newly added parts in Table 2 (i.e. not tested in the first test).

There is no direct relationship between the two tables, because both tables are connected to another table (the total part number list) by Part number, The part numbers are in text type in both tables.

Table 1

Part NumberVoltageResult
900-0008C00000031745.1FAIL
900-0008C00000033743.9PASS
900-0008B00000033833.5PASS
900-0008C00000033843.2PASS
900-0009C00000033874.8PASS
900-0008C00000033894.9PASS
900-0007C00000033905.7FAIL
900-0008C00000033926.1FAIL
900-0008C00000033944.3PASS
900-0007B00000033953.8PASS
900-0008C00000033962.3PASS
900-0008B00000033977.2FAIL
900-0007C00000033982.4PASS
900-0008C00000033991.8PASS
900-0007B00000034013.6PASS

 

Table 2

Part NumberVoltageResult
900-0008C00000033743.9PASS
900-0008B00000033833.5PASS
900-0008C00000033843.2PASS
900-0009C00000033875.9FAIL
900-0008C00000033894.9PASS
900-0008B00000031813.6PASS
900-0008C00000033991.8PASS
900-0007B00000034013.7PASS
900-0008C00000033944.5PASS
900-0007B00000033953.8PASS
900-0008C00000033962.3PASS
900-0007B00000013264.4PASS
900-0007C00000033982.4PASS
900-0007B00000011495.8FAIL
900-0007C00000018913.6PASS
1 ACCEPTED SOLUTION
OC101
Frequent Visitor

Thanks vicky_! It works.

View solution in original post

3 REPLIES 3
vicky_
Super User
Super User

My data model looks like the following, although i suspect that your table will have 1:M instead of 1:1

vicky__0-1719354437098.png

Assuming you want your result as a DAX measure:

Newly Added = COUNTROWS(
    EXCEPT(VALUES('Table 1'[Part Number]), VALUES('Table 2'[Part Number]))
)

which gives the following result:

vicky__2-1719354580581.png

 

OC101
Frequent Visitor

Hi vicky_,

Thanks for your reply! Besides the number of new parts, I also need to know the Part Numbers of the new parts.

OC101
Frequent Visitor

Thanks vicky_! It works.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors