How do i duplicate rows

Question

How do I duplciate rows based on column value in another tableE.g.Table 1Customers&nbsp; &nbsp;Sales Number&nbsp; Order Number&nbsp; YearAlex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2015Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2016Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2017Table 2Customers&nbsp; &nbsp;Sales Number&nbsp; Order Number&nbsp; Sales&nbsp; &nbsp;Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400Desired OutputCustomers&nbsp; &nbsp;Sales Number&nbsp; Order Number&nbsp; Sales&nbsp; &nbsp;YearAlex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp;2015Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp;2016Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp;2017Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp;2015Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp;2016Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 300&nbsp; &nbsp; &nbsp;2017Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp;2015Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp;2016Alex&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1111111&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;111222&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 400&nbsp; &nbsp; &nbsp;2017I 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&nbsp; &nbsp;Sales Number&nbsp; Order Number"

amitchandak · Accepted Answer

ephramz , merge on name, or order number and then expend 
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
&nbsp;
Crossjoin or generate with filter in DAX
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/

Forum Discussion

How do i duplicate rows

2 Replies

Related content

remove duplicate value within a row

Duplicate rows in dataflow

Add duplicate row based on column

Duplicate ranking

DAX command to duplicate rows