cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nagoor Regular Visitor
Regular Visitor

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,

 

1 ACCEPTED SOLUTION

Accepted Solutions
nagoor Regular Visitor
Regular Visitor

Re: Calculating a column in different table with unique filed

Thanks for your response.. 

 

6 REPLIES 6
svalen Member
Member

Re: Calculating a column in different table with unique filed

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

Is this clear?

nagoor Regular Visitor
Regular Visitor

Re: Calculating a column in different table with unique filed

No, Please find the below queries, hope it clears 

 

Table 1 

image.png

Table2

image.png

 

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

svalen Member
Member

Re: Calculating a column in different table with unique filed

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 Regular Visitor
Regular Visitor

Re: Calculating a column in different table with unique filed

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?

svalen Member
Member

Re: Calculating a column in different table with unique filed

Yes, of course it is possible.

 

Like I told you:

 

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

 

You link the two fields (IDs) on the diagram and then create the table on the report view with whatever you like. No need for SUMIFs.

 

It's different from Excel, that's the point.

nagoor Regular Visitor
Regular Visitor

Re: Calculating a column in different table with unique filed

Thanks for your response.. 

 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 42 members 1,006 guests
Please welcome our newest community members: