2 Tables _ Combine _ RANKX

[MasterSonic]

Hi guys,

I have a quick question, maybe you can help.

Table 1

Code	Plan	Group	Arrival date	other column
1	CCC/a	Windows	1/1/2020
2	CCC/a	Windows	1/1/2020
3	CCC/a	Lock	1/1/2020
101	CCC/a	Lock	1/1/2010
203	CCC/b	Door	2/1/2010
205	CCC/b	Door	2/1/2010
206	CCC/b	Door	2/1/2010
205r	BBB/a		2/1/2010

Table 2

Plan	Group	Class	Sold Date
CCC/a	Windows	Hard	1/1/2000
CCC/a	Lock	Medium	1/1/2005
CCC/b	Door	Medium	20/04/2020

What I can do is to create table visual like this

Code	Class	Sold Date	Plan
203	Medium	20/04/2020	CCC/b
205	Medium	20/04/2020	CCC/b
206	Medium	20/04/2020	CCC/b

What I would like to do is to do this:

Code	Class	Sold Date	Plan
1	Hard	1/1/2000	CCC/a
2	Hard	1/1/2000	CCC/a
3	Medium	1/1/2005	CCC/a
101	Medium	1/1/2005	CCC/a

Could you help me with that please ? 

Plan is calculated column with Rankx.

[v-jayw-msft]

Hi @MasterSonic ,

Have trouble to follow.

Please explain the logic about the calculation.

Best Regards,

Jay

[MasterSonic]

Hi Jay, confusing post. Sorry for that.

I have amended one thing in my question too.

Tables are linked with Plan columns.

If I drag code field (203,205,206) into to the table chart, it displays correctly class and sold date.

But for 1,2,3,101 who belong to Plan CCC/a (table1), we have duplicated CCC/a value in table2.

My visual duplicates 1,2,3,101 for values from table2.

Eg. Sold date will be printed for all of these 1/1/2000 and again 1/1/2005. 

Where it should be as a wanted results table as a shown.

 I would like group from table1 works as an extra reference with Code

Is it possible?