Forum Discussion

nagoor's avatar
nagoor
Icon for Helper III rankHelper III
8 years ago
Solved

Calculating a column in different table with unique filed

Hi All,   I want to calculate the in two different table when the first column matches.  eg., First Table --> I have a table with Emp ID and all the details about the emp. Sec Table --> I have h...
Need Help
  • nagoor's avatar
    nagoor
    8 years ago

    Thanks for your response.. 

     

Anonymous's avatar
Anonymous
Not applicable
8 years ago

For that you create relations on the relation diagram and then create the visuals accordingly,

Is this clear?

  • nagoor's avatar
    nagoor
    Icon for Helper III rankHelper III
    8 years ago

    No, Please find the below queries, hope it clears 

     

    Table 1 

    Table2

     

    I'll use =SUMIFS('Table 2'!C:C,'Table 2'!A:A,'Table 1'!B:B) this to calculate my values, pls help how to do the same in powerbi

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      What do you want to calculate exactly?

       

      If you want to do it like in Excel, do it in Excel, PBI is a little different.

       

      The relations in PBI make it easy to do those calculations.

      • nagoor's avatar
        nagoor
        Icon for Helper III rankHelper III
        8 years ago

        The concern here I have huge data to proceed where I need to do it powerbi to do some analysis. the example shown was for easy understanding of my query. But the response to go back with Excel is not satisfied. 

         

        Does this we don't have any other option to do?