Forum Discussion
Solved
Relationship Between 2 Data Sources - Add 1 column from 1 source to the other
Hi Power BI Community, I have the below 2 seperate data sources that look something like this: Table 1 ID Country Region 1 USA North America 2 USA North America 3 Singapo...
You'll probably need to show another example to demonstrate your new issue.
For your last comment "I don't have any blanks in table 2 for dates", your initial post stated that you did. I'm not sure how many rows you are dealing with, but Query Editor only shows a sampling of data and blank date fields may or may not be in your sample, regardless, you can still apply the replace values step.
If you are talking about a Visual, you can choose to "Show items with no Data"
Otherwise, I'd add a Date value of some sort into Table 2 via Query Editor for all blanks, such as '1/1/1900'