Forum Discussion
Cross reference another table to retrieve text value
Hello! I am trying to reference a table that has a list of activities to a table that has a list of purchases that "should" have the activities as the first characters of the description. E.g. Tabl...
Hi PowerBIGpig ,
Could you please check if the rows with Unknowns has any matched rows in table 'Activity List' ? (same WBS and Activity is part of Purchasing Item Text)
Best regards,
Hi v-lid-msft ,
The Activity List is a list of all WBS/Activity Codes, e.g.
| Activity | WBS | Work Package |
| EW.1.1 | PROJ-100001 | EW |
| EW.2.1 | PROJ-100001 | EW |
| EW.3.1 | PROJ-100001 | EW |
| Unknown1 | PROJ-100001 | EW |
| SS.2.2 | PROJ-100002 | SS |
| Unknown2 | PROJ-100002 | SS |
The Acc/Act/Comm/Web table has all items purchased, it primarily has the WBS (exact as listed above), and the Line description which (usually) has the Activity listed in the start e.g. EW.1.1. If it doesn't have the Activity name in the string, then it can be listed as unknown, but only if the Activity isn't there.