Forum Discussion
Solved
Left Join
Hi Ive been trying to left join tables (like you would in SQL) where any rows that dont match (in the right table) return nulls. Ive come up with the follwoing work around but it seems very long wi...
are you sure, you need left join?
In most cases it's enough to create relationships between tables and then set parameter "Show items with no data in visual" https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data
are you sure, you need left join?
In most cases it's enough to create relationships between tables and then set parameter "Show items with no data in visual" https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data
az38 Thanks for your reply. I thought my workaround was very long winded. Your answer sorts it. Thanks again.