Merge two columns with different size

[danyac1591]

Hello everyone, 

I have 2 tables in PBI Desktop, one has date+time (8760 rows) and the other one has 10 names (10 rows). I need to merge both columns into one table in wich I'll have the same day and the same hour 10 times, each row with a different name.

I can't do the merge in Power Query because I created the table with DAX in PBI Desktop.

Is this kind of merge possible?

[rajulshah · Accepted solution]

Hello @danyac1591,

Please try using CROSSJOIN  function.

Hope this helps.