Create a new table with columns from existing tables

[RSchaef]

Hi there, 

I am really new to Power BI and am excited about the opportunities with it.

I am doing somehting that seems simple, but I am struggling.

I work in the automotive industry.

I have one table (Sales Table) that has all the vehicles we have sold and one table that shows all the vehicles we have purchased and how they were purchased (Purchases Table).

Both tables are related by the vehicle VIN - 17 digits.

I want to make a new table that compares the VINs on the Sales table with the VINs on the Purchases Table and if the VIN on the Sales table is listed on the Purchases Table, I want a result of "Lead" and if the VIN on the Sales Table is not on the Purchases Table, then a result of NON LEAD.  

I then want to put LEAD and NON LEAD as a chicklet slicer to filter data.

Help please!

[stretcharm · Accepted solution]

There are several ways you could do this.

You can do it in query editor by createding a merge as new of the 2 tables.

A conditional formated expression would allow the LEAD/NON LEAD Status.

A chicklet or sliced would let you filter this merged table but not the other tables unless they are also joined.

I would probably join the 2 tables and add a new computed column on the Sales table to see if there is a match.

LeadStatus = if(ISBLANK(RELATED(Purchases[VIN])), "LEAD","NOT LEAD")

[RSchaef]

Thank you!  Worked great