Forum Discussion
Return "Specific value" from table 1, if not found, return value from table 2
Hi, I found a solution by apending the two tables, concatenating both Proj Name columns and filtering out the blank and duplicates.
Thank you all for your replies.
Impactful IndividualHello,
I would need to know a bit more about how the Project Number connects to each table. One way to consider is to create a crosswalk between your two tables containing a list of unique project numbers, and connect Table A and B to this cross walk.
From there, you can then just pull in the Project number into the slicer to filter Tables A and B respecitvely - no calculated formulas needed.
Again, without knowing much of your data, this answer may change if the two project tables are not mutually exclusive.
There are multiple tables, all joint by the project number. However, not all have the project name. Only two tables have this information. I could merge them and create a unique proj name column(table) but I thought a calculated formula was doable.