cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nagoor
Helper II
Helper II

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

Thanks for your response.. 

 

View solution in original post

6 REPLIES 6
svalen
Responsive Resident
Responsive Resident

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

Is this clear?

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
Responsive Resident
Responsive Resident

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.

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
Responsive Resident
Responsive Resident

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.

Thanks for your response.. 

 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors