Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
How do I duplciate rows based on column value in another table
E.g.
Table 1
Customers Sales Number Order Number Year
Alex 1111111 111222 2015
Alex 1111111 111222 2016
Alex 1111111 111222 2017
Table 2
Customers Sales Number Order Number Sales
Alex 1111111 111222 200
Alex 1111111 111222 300
Alex 1111111 111222 400
Desired Output
Customers Sales Number Order Number Sales Year
Alex 1111111 111222 200 2015
Alex 1111111 111222 200 2016
Alex 1111111 111222 200 2017
Alex 1111111 111222 300 2015
Alex 1111111 111222 300 2016
Alex 1111111 111222 300 2017
Alex 1111111 111222 400 2015
Alex 1111111 111222 400 2016
Alex 1111111 111222 400 2017
I know that there is a custom column in the power quer editor, however im unsure what the formula might be.
The 2 table have matching columns "Customers Sales Number Order Number"
Solved! Go to Solution.
@ephramz , merge on name, or order number and then expend
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Crossjoin or generate with filter in DAX
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Use Merge Queries in Query Editor - https://docs.microsoft.com/en-us/power-query/merge-queries-overview
Best Regards,
Siva Mani
Proud to be a Super User!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Use Merge Queries in Query Editor - https://docs.microsoft.com/en-us/power-query/merge-queries-overview
Best Regards,
Siva Mani
Proud to be a Super User!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ephramz , merge on name, or order number and then expend
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Crossjoin or generate with filter in DAX
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/