Forum Discussion
Solved
Return "Specific value" from table 1, if not found, return value from table 2
Hello, I have Table A and Table B, and I need to create a visual to show the Project Name when selecting a Project Number. Is it possible to create a calculated formula to return Proj Name if foun...
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.
Kedar_Pande
Super User
Super User
Project Name =
VAR ProjNum = YourTable[Project Number]
VAR NameA = LOOKUPVALUE(TableA[Proj Name], TableA[Project Number], ProjNum)
RETURN
IF(
ISBLANK(NameA),
LOOKUPVALUE(TableB[Proj Name], TableB[Project Number], ProjNum),
NameA
)