Forum Discussion
Repeat Data in Power Query
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
1 Reply
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
