Merge: Left Join Returns all Date Columns as Blank other columns fine

Hi there,

I have a starting table called Opportunities which I join to Quotes. The join works great, the data types are aligned. When I expand the columns it works well except for the date columns. They return blank even though there is data in the Quotes table.

ColumnsExpanded
ExpandedColumns

@SammiP Did you load data into PBI? Is it possible that the query is slow and Power Query is not able to show all the values?

No. The data is not slow and even when I join in SQL I get the Same Results. I just brought the data into Excel and did a Vlookup. It turns out those records are actually blank. Thanks for the help. This is now results.