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; ...
pls see if this is what you want. you can select differnt org code to see different result
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 below
Thanks ryan_mayu ,
but can you tell me how do i compare all the other routes simultaneuosly, not just 1
pls see if this is what you want. you can select differnt org code to see different result
you are welcome