Forum Discussion
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 "Date Set"
The two tables are linked by "Legal Name". This works fine. I can bring Legal Name, Open Date and Date Set into a visualization.
I would like to calculate elapsed days by comparing the "Open Date" and "Date Set". Do I do this in the Query Editor? Or, do I add a custom column to OPEN DATE or DATE SET?
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.
6 Replies
Maybe you could merge the two tables, that would make it easier for you to create a measure that calculate the difference.
/Magnus
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?
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.
I 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.
