Forum Discussion
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
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/
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
MaggieCommunity 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.
2 Replies
Hi Anonymous ,
Try:
M1 = Sum (Table1[ColumnA])
M2 = Sum (Table2[ColumnX])
M3 = Sum (Table3[ColumnZ])
MFinal = M1+M2+M3
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielHi 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/
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
MaggieCommunity 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.
