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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MasterSonic
Helper IV
Helper IV

2 Tables _ Combine _ RANKX

Hi guys,

I have a quick question, maybe you can help.

Table 1

Code PlanGroup Arrival dateother column
1CCC/aWindows 1/1/2020 
2CCC/aWindows 1/1/2020 
3CCC/aLock1/1/2020 
101CCC/a Lock1/1/2010 
203CCC/b Door2/1/2010 
205CCC/b Door2/1/2010 
206CCC/b Door2/1/2010 
205rBBB/a 2/1/2010 


Table 2

PlanGroupClassSold Date
CCC/a WindowsHard1/1/2000
CCC/a LockMedium1/1/2005
CCC/b DoorMedium20/04/2020

 

What I can do is to create table visual like this

 

CodeClassSold DatePlan
203Medium 20/04/2020 CCC/b
205Medium 20/04/2020 CCC/b
206Medium 20/04/2020 CCC/b

 

What I would like to do is to do this:

CodeClassSold DatePlan
1Hard 1/1/2000 CCC/a
2Hard 1/1/2000 CCC/a
3Medium 1/1/2005 CCC/a
101Medium 1/1/2005 CCC/a

 

Could you help me with that please ? 

Plan is calculated column with Rankx.

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

Hi @MasterSonic ,

 

Have trouble to follow.

Please explain the logic about the calculation.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

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?

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors