Forum Discussion
patrick3
5 years agoHelper II
DAX - New table, adding specific values based on original column
Hi all, Not 100% sure how to explain this, but I'll try. Let's say ive got a table with 2 columns: UserId, Package Code And another table with 2 columns: Package Code, Product Code ...
- 5 years ago
Hi,
In the Query Editor, merge Table2 into Table1 based on the Package Code. If a Package code has multiple Product codes, then multiple lines will get created in the merged dataset.
patrick3
5 years agoHelper II
Hi,
That would work, except I will need to do further calculations on the table, which cannot be done just in a measure
Ashish_Mathur
5 years agoSuper User
Hi,
In the Query Editor, merge Table2 into Table1 based on the Package Code. If a Package code has multiple Product codes, then multiple lines will get created in the merged dataset.