Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In the Power BI left outer join query, how should I get actual values from the table to replace null values for the unmatched rows.
Thanks.
Solved! Go to Solution.
Hi @ramesh0716
Maybe you can try Full outer join instead of Left outer join. With Full outer join, the unmatched rows from the right table will be grouped to a null row. But in the grouped table, it has all the unmatched values from the right table. You can then expand these unmatched values. Is this what you want?
Reference: Full outer join - Power Query | Microsoft Learn
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hi @ramesh0716
Maybe you can try Full outer join instead of Left outer join. With Full outer join, the unmatched rows from the right table will be grouped to a null row. But in the grouped table, it has all the unmatched values from the right table. You can then expand these unmatched values. Is this what you want?
Reference: Full outer join - Power Query | Microsoft Learn
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Hello @ramesh0716 .
Left join will get the matching rows from the right query and will return all the rows from the left query even if they don't match. In that case, values from right query results would be shown as blank.
Can you share a sample of dataset that you have been working with?
Thanks,
Abhinav