Forum Discussion
ckennedy
8 years agoFrequent Visitor
Mult Data Sources
Hello. I'd like to compare dates from two linked tables. The first table is OPEN DATE with two columns: "Legal Name" and "Open Date" The second table is DATE SET with two columns "Legal Name" and "...
- 8 years ago
You can create a Merge Query in Power Query editor. All the way to the right in the ribbon. There are also functions like NATURALLEFTINNERJOIN in DAX that you could do this with.
ckennedy
8 years agoFrequent Visitor
Thanks for the quick reply. I'm still getting the hang of Power BI at this point. How do you merge tables? Is this done through the query editor?
Greg_Deckler
8 years agoCommunity Champion
You can create a Merge Query in Power Query editor. All the way to the right in the ribbon. There are also functions like NATURALLEFTINNERJOIN in DAX that you could do this with.
- ckennedy8 years agoFrequent Visitor
Thank you! That's what I needed.