Forum Discussion
Solved
Comparing multiple Organizations with Base Organization
Hi Everyone,
i have a dataset with org codes and routes (please find a sample below),
i want to fix 'A' as my base client and i want to compare the base routes to the routes of all other clients;
then further show the differences in a table against each organizations
Sample:
| Route | Org Code |
| Bangladesh-Chattogram-Durban-Durban-Port Elizabeth-Standard | B |
| Belgium-Antwerpen-Direct-Durban-Durban-Standard | A |
| Belgium-Antwerpen-Direct-Durban-Durban-Standard | B |
| Belgium-Antwerpen-Direct-Port Elizabeth-Port Elizabeth-Standard | A |
| Belgium-Antwerpen-Direct-Port Elizabeth-Port Elizabeth-Standard | C |
| Belgium-Antwerpen-Direct-Port Elizabeth-Port Elizabeth-Standard | B |
| Belgium-Antwerpen-Durban-Durban-Johannesburg-Standard | A |
| Belgium-Antwerpen-Durban-Durban-Johannesburg-Standard | C |
| Belgium-Antwerpen-Durban-Durban-Johannesburg-Standard | B |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Cape Town-Express | A |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Cape Town-Express | C |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Cape Town-Express | B |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Cape Town-Standard | A |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Cape Town-Standard | C |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Cape Town-Standard | B |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Durban-Express | A |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Durban-Express | B |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Johannesburg-Express | A |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Johannesburg-Express | C |
| Belgium-Antwerpen-Port Elizabeth-Port Elizabeth-Johannesburg-Express | B |
| Belgium-Antwerpen-Richards Bay-Richards Bay-Durban-Express | C |
| Brazil-Itajai-Durban-Durban-Cape Town-Standard | B |
Eg:-
when i compare A with B
i should see the following
| Bangladesh-Chattogram-Durban-Durban-Port Elizabeth-Standard | B |
| Brazil-Itajai-Durban-Durban-Cape Town-Standard | B |
pls see if this is what you want. you can select differnt org code to see different result
9 Replies
you can try this to get the result
Table 2 =VAR _compare1="A"VAR _compare2="B"return ADDCOLUMNS(EXCEPT(SELECTCOLUMNS(FILTER('Table','Table'[Org Code]=_compare2),"Route",'Table'[Route]),SELECTCOLUMNS(FILTER('Table','Table'[Org Code]=_compare1),"Route",'Table'[Route])),"org code",_compare2)pls see the attachment belowThanks ryan_mayu ,
but can you tell me how do i compare all the other routes simultaneuosly, not just 1pls see if this is what you want. you can select differnt org code to see different result
