Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
HugoDataAve2023
Frequent Visitor

Left outer join missing values

I am using a left outer join to match two tables according a index. I need the nonmatched from the first, to calculate some rate. The problem is that, when I expand, the rows that should come with null values just disappear. This wrong in a lot of sense, since will become a inner join. 

 

Before expand

HugoDataAve2023_0-1702383051712.png

 

After expand:

 

HugoDataAve2023_1-1702383185149.png

 

Where is zero????????

 

This is so wrong. I will miss a entire work when if I don't fix that.

 

1 ACCEPTED SOLUTION
HugoDataAve2023
Frequent Visitor

I find the problem, the null observation was there, but I didnt uploaded all rows. My bad.

View solution in original post

1 REPLY 1
HugoDataAve2023
Frequent Visitor

I find the problem, the null observation was there, but I didnt uploaded all rows. My bad.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors