Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 only one table, not the other one. I need help in it.

 

Thanks in advance

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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 ? 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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