Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Hi @MasterSonic ,
Have trouble to follow.
Please explain the logic about the calculation.
Best Regards,
Jay
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?
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |