Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Operating three columns from three different tables

Hello, what I am trying to do is sum three columns from three diffetn tables. Any ideas or suggestions on how to do that would be great, thanks

General Comment

Tips and Tricks

Tutorial Requests

v-juanli-msft
6 years ago
Hi Anonymous

Please create relationships among these tables,

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Then you can sum for mutiple columns using DAX

https://www.c-sharpcorner.com/article/sum-multiple-column-using-dax-in-power-bi/

Or use lookup function.

Some similar threads you could refer to;

https://community.powerbi.com/t5/Desktop/Sum-of-to-many-on-different-tables/td-p/484705

https://community.powerbi.com/t5/Desktop/Create-a-Calculated-Column-from-Different-Tables/td-p/60453

Best Regards
Maggie

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

Community Support

6 years ago

Hi Anonymous

Please create relationships among these tables,

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Then you can sum for mutiple columns using DAX

https://www.c-sharpcorner.com/article/sum-multiple-column-using-dax-in-power-bi/

Or use lookup function.

Some similar threads you could refer to;

https://community.powerbi.com/t5/Desktop/Sum-of-to-many-on-different-tables/td-p/484705

https://community.powerbi.com/t5/Desktop/Create-a-Calculated-Column-from-Different-Tables/td-p/60453

Best Regards
Maggie

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