Mult Data Sources

[ckennedy]

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?

[Greg_Deckler]

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.

[MagnusSthlm]

Maybe you could merge the two tables, that would make it easier for you to create a measure that calculate the difference.

/Magnus

[ckennedy]

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?

[MagnusSthlm]

Hi!

Yes you merge in the Query Editor. Here's a video showing how to do it:

https://www.youtube.com/watch?v=A1OgxKZmbqg

[Greg_Deckler · Accepted solution]

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]

Thank you! That's what I needed.