cancel
Showing results for
Did you mean:
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
Regular Visitor

6 REPLIES 6
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?

Regular Visitor

## Re: Calculating a column in different table with unique filed

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

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.

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?

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.

Regular Visitor

## Re: Calculating a column in different table with unique filed

Announcements

#### Back to School Contest

Engage and empower students with Power BI!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

#### Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Top Kudoed Authors
Users Online
Currently online: 240 members 2,577 guests
Recent signins: