How to input calculated columns for two different tables in power BI

[gupta_diksha]

Hi,

I've inserted two excel files together in Power BI but did not made any relationship between them. I want to insert calculated columns in both tables separately but I am able to insert it in only one table, not the other one. I need help in it.

Thanks in advance

[amitchandak]

@gupta_diksha ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[gupta_diksha]

Hi,

Thank you for replying. Here you can see I have two tables. I am able to add calculated comumn for Sheet 1 but Not for Sheet 1(2). Why is it like this? Also do I need to make any relationship ? 

[v-jayw-msft]

Hi @gupta_diksha ,

What you mean you can't add calculated column to table2, is there any error message?

And can you share the formula to us?

Best Regards,

Jay