cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RSchaef Frequent Visitor
Frequent Visitor

Create a new table with columns from existing tables

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!

1 ACCEPTED SOLUTION

Accepted Solutions
stretcharm Senior Member
Senior Member

Re: Create a new table with columns from existing tables

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")

 

 

View solution in original post

2 REPLIES 2
stretcharm Senior Member
Senior Member

Re: Create a new table with columns from existing tables

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")

 

 

View solution in original post

RSchaef Frequent Visitor
Frequent Visitor

Re: Create a new table with columns from existing tables

Thank you!  Worked great

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 392 members 4,494 guests
Please welcome our newest community members: