Forum Discussion
MULTIPLE ROWS FOR OTHER TABLE BASED ON ID
Hello everyone. Trying to create custom table, based on another table.
1st table (already have):
| PRODUCT ID | MATERIALS | WEIGHT FOR 1 KG |
| AU10 | STEEL | 10 |
| AU10 | WATER | 20 |
2nd table (already have):
| ORDER NUMBER | PRODUCT ID | QUANTITY |
| 12345 | AU10 | 1000 |
TABLE TO BE MADE:
| ORDER NUMBER (1) | PRODUCT ID (2) | MATERIALS (3) | WEIGHT FOR 1 KG (4) |
| 12345 | AU10 | STEEL | 10 |
| 12345 | AU10 | WATER | 20 |
Please tell me how to create new table which imports info from table 1 and multiples order numbers in each row?
THANK YOU!
Thats not a DAX Question.
Do it in PowerQuery. Just merge the tables in PowerQuery via the Product ID, the rest will be done automatically.
1 Reply
Thats not a DAX Question.
Do it in PowerQuery. Just merge the tables in PowerQuery via the Product ID, the rest will be done automatically.