Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Create a table using Distinct values from another table

Let's say I have two tables ORDERS -------- Order_Num, Material_Code, etc., etc., Ord001, 1001 Ord002, 1002 Ord003, 1003 Ord004, 1003 Ord005, 1001 MATERIALS ------------- Material_C...

v-jianboli-msft
3 years ago
Hi Anonymous ,

Please try:

Table = FILTER('MATERIALS',[Material_Code] in VALUES(ORDERS[ Material_Code]))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Create a table using Distinct values from another table.pbix29 KB

v-jianboli-msft

Community Support

3 years ago

Hi Anonymous ,

Please try:

Table = FILTER('MATERIALS',[Material_Code] in VALUES(ORDERS[ Material_Code]))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Create a table using Distinct values from another table.pbix29 KB

Forum Discussion

Create a table using Distinct values from another table

Related content

Create a table of distinct value from another table

Count Distinct Values based on another column in Power Query

count distinct

Count distinct values in one column, grouped by another column

Create New Table Based on DIstinct Values of One Column and Calculated Values of Another Column