Forum Discussion

lcm7721's avatar
lcm7721
Frequent Visitor
6 months ago
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...
Need Help
  • lcm7721's avatar
    lcm7721
    6 months ago

    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.

v-pnaroju-msft's avatar
v-pnaroju-msft
Icon for Community Support rankCommunity Support
6 months ago

Hi lcm7721,

We are pleased to note that your issue has been resolved. Thank you for sharing your insights and approach in resolving the issue, which will be beneficial to other members of the community. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.