Creating a Calculated Column from Two Different Tables

[Anonymous]

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

[v-piga-msft · Accepted solution]

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

[Ashish_Mathur]

Hi,

Share a dataset and also show the expected result.

[Zubair_Muhammad]

@Anonymous

As a calculated column on one side table...normally we can use

Column in Table X= Calculate(sum(TableY[ColumnName]))