Forum Discussion

ckennedy's avatar
ckennedy
Frequent Visitor
8 years ago
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 "...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    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.

MagnusSthlm's avatar
MagnusSthlm
Icon for Helper I rankHelper I
8 years ago

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

 

/Magnus

ckennedy's avatar
ckennedy
Frequent Visitor
8 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    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's avatar
      ckennedy
      Frequent Visitor
      8 years ago

      Thank you! That's what I needed.