Forum Discussion

nunnc01's avatar
nunnc01
Helper II
5 years ago
Solved

Combining data in Power query

Hi,   I have a table in Power Query that has a Unique ID and a month end date. Each ID can have multiple rows, each with a different month end date similar to this:   Unique ID    Month End ID 1...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi nunnc01 

     

    Download sample PBIX

     

    I'd create a new column in Table2 with the month end date for the month in Start Date. 

    You can then merge the tables on the ID and Month End Columns

    Giving this

    Regards

    Phil

     

PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi nunnc01 

 

Download sample PBIX

 

I'd create a new column in Table2 with the month end date for the month in Start Date. 

You can then merge the tables on the ID and Month End Columns

Giving this

Regards

Phil