Need some help with a comparison of two table visuals. One table (table A) has vehicles received and the other table (table B) has a list of vehicles that had a certain accessory installed. Both contain a similar field called VIN.
I need to know which VINs from Table A are not in Table B. Attempts to use "does not contain for the accessory code" fails with resource errors. I do this all the time in Microsoft Access but have not in Power BI so would like to know how. Thanks for any assistance.
Table screen shots are below.
Hi mike.
See this example Table1 and table2. BB is missing in table 2
1- Make the relationships of the model
2 - make a table visual and in FILTERs select TABLE2 advanced filter IS BLANK.
See pictures below
Hi mike.
See this example Table1 and table2. BB is missing in table 2
1- Make the relationships of the model
2 - make a table visual and in FILTERs select TABLE2 advanced filter IS BLANK.
See pictures below
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
