Forum Discussion
Solved
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 "...
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.
Greg_Deckler
Community Champion
Community ChampionI would create a measure that does a subtraction of the MAX of the two dates or use DATEDIFF. This will work in a context of Legal Name in a table.