Repeat Data in Power Query

[Anonymous]

Hi All,

I have a static table with 53 records, and i want to add this static table to my db to be repeated 53 times.

Example: i have filtered with one Unit name, and the static table should have all information of 53 records for each unit name from DB 

Please suggest, if any solution on this at power query editor

[amitchandak]

@Anonymous , In case you ned cross join in power query

Power Query Cross Join| Cartesian Product: https://youtu.be/7MvROGObBYk

With common column, you can try merge tables

Merge Tables (Power Query) : https://youtu.be/zNrmbagO0Oo