Concatenate rows from unrelated data sources

[all40]

Hello everyone,

First time poster and new Power BI user, so please excuse me if this is unclear.  I would like to concatenate data from two, unrelated CSV files in Power BI Query Editor and can't figure it out.  

For example, I have two CSV files (Name and Dates).  I have imported them into Power BI as 2 separate data sources.  I would like a new resulting query to be a concatenation of Name for every distinct date in the Dates file.

If my Names dataset consisted of "Jim" and "Bill" and Dates dataset of "1/1", "1/2", and "1/3", I would like the new query to contain "1/1Bill", "1/2Bill", "1/3Bill", "1/1Jim", "1/2Jim", and "1/3Jim".

Any help and/or guidance would be greatly appreciated.  Thank you in advance!

-Alex.

[Ashish_Mathur · Accepted solution]

Hi,

You may refer to my solution in this file.