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

Thankyou, Gabry, ExcelMonke, cengizhanarslan ,Kedar_Pande and danextian for your responses.

Hi lcm7721,

Based on our understanding of the scenario, please find attached the screenshots and a sample PBIX file that may assist in resolving the issue.


We hope the information provided will help resolve the issue. Should you have any further queries, kindly feel free to contact the Microsoft Fabric Community.


Thank you.