topic Re: Creating a Calculated Column from Two Different Tables in Desktop

Creating a Calculated Column from Two Different Tables

Anonymous — Fri, 11 May 2018 17:26:36 GMT

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

Re: Creating a Calculated Column from Two Different Tables

Zubair_Muhammad — Fri, 11 May 2018 20:56:13 GMT

Anonymous

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

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

Re: Creating a Calculated Column from Two Different Tables

Ashish_Mathur — Fri, 11 May 2018 23:51:59 GMT

Hi,

Share a dataset and also show the expected result.

Re: Creating a Calculated Column from Two Different Tables

v-piga-msft — Mon, 14 May 2018 06:18:28 GMT

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