cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pcowman1 Frequent Visitor
Frequent Visitor

Summarize two columns different tables linked through third

I've been trying to do this through summarize and a new table but can't for the life of me figure out how to what I need.

 

I have 3 tables one is an Item List which has a unique key. the other two do not have anything unique to allow them to talk to each other so they go through Item List. 

 

All three have Item Number which is the list's key.

 

I need to summarize a column from each by the Item Number to allow for filtering by Item Number. How do you write a column to summarize by the key? can I summarize to the Item List table?

1 REPLY 1
Community Support Team
Community Support Team

Re: Summarize two columns different tables linked through third

Hi @pcowman1 

 

It seems you may create a table with below formula.If it is not your case,please share some data sample and expected output. You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.For further,please refer to

How to Get Your Question Answered Quickly.

Table =
DISTINCT (
    UNION (
        SELECTCOLUMNS ( Table1, "List", Table1[List] ),
        SELECTCOLUMNS ( Table2, "List", Table2[Item list] ),
        SELECTCOLUMNS ( Table3, "List", Table3[Item list] )
    )
)

Regards,

Cherie

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.