Forum Discussion
Creating a Calculated Column from Two Different Tables
Hello,
I am trying to figure out how to creating a new column using different tables.
Table X and Table Y have a one to many relationship.
I basically want to sum an integer type column for each row from Table Y that matches with Table X. So I am assuming the new column should be on Table X.
Just started using Power BI so I apologize beforehand if I am missing any important info.
Thanks
Hi Anonymous,
Have you solved your problem with the answer of Zubair_Muhammad?
If you have soved your question, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, could you share a dummy pbix file which can reproduce the scenario and your expected output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
3 Replies
Anonymous
As a calculated column on one side table...normally we can use
Column in Table X= Calculate(sum(TableY[ColumnName]))
Hi,
Share a dataset and also show the expected result.
Hi Anonymous,
Have you solved your problem with the answer of Zubair_Muhammad?
If you have soved your question, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, could you share a dummy pbix file which can reproduce the scenario and your expected output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)
Best Regards,
Cherry
