Calculation

[Anonymous]

I have two tables which i wanted to join based on "Student_Id" hence i merge the tables but now if i am creating any calculation where columns are from both the tables, the column name is not showing while creating calculation.

For Example:

Table A - Column A

Table B - Column B

I tried Merge Queries & Merge Quieries New but for both options while creating Calcualtion(New Column) one of the existing column name (Column A or Column B) not showing.

I also tried to make relationship between tables but still unable to see column name while creating calcualtion.

[Anonymous]

Hi @Anonymous ,

Please have a try.

I have created a simple similar example.

Then merge the two tables.

Then expand the table.

Then we can calculate on the new table.

If  I have misunderstood your meaning, please contact me with some sample data and desired output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[bcdobbs]

Are you able to share a demo pbix file?