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 how many hours a day the particular emp worked on this month. 

 

in excel used "SUMIFS", can anyone help me on DAX coding

 

Thanks,

 

Need Help

6 Replies

  • 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.