Forum Discussion
How to input calculated columns for two different tables in power BI
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 ...
amitchandak
Super User
Super UserAnonymous ,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
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 ?
Hi Anonymous ,
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