Forum Discussion
Lookupvalue when Value doesn't exist in One Table
Hi All, I have two tables - A CSR and a Milestones Table. They are joined on the CSR field. Some CSRs don't exist in the Milestones table (See column 3 in the screenshot - CSR-0329 does not exi...
Anonymous ,
I don't want to hardcode it as there are other such cases in my dataset.
Hi kartiklal70 ,
You'd better provide some sample data of your two tables, along with the expected results.
I need more details.
Is there a relationship between the two tables?
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ,
Link to Sample Power BI Report.
https://www.dropbox.com/s/piq5xhqxwo1mmjd/Sample%20Power%20BI%20Report.pbix?dl=0
Expected Results for Calculated Column: