cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Power BI SUMIFS on another table

Hello everybody

I have a maybe easy question but I dont find the way to do it easily :

Table1 :

 A B C Peter 10 Daughter Franck 20 Son Mark 30 Daughter

Table2 :

 D E F Peter Peter_Son 100 Peter Peter_Daughter 450 Franck Franck_Son 600

I woud like : a sumifs + concatenate => SUMIFS(Table2[ColonneF], Column_E = (Column_A & Column_C) ) )  onthe table1

I dont have a direct unique key between the two tables that is why the join is a little bit complicated.

Kind regards, thanks !

1 ACCEPTED SOLUTION
Community Support

Hi @Anonymous ,

You can create a calculated column as below in Table1:

``````Column =
CALCULATE (
SUM ( 'Table2'[F] ),
FILTER ( 'Table2', 'Table2'[E] = 'Table1'[A] & "_" & 'Table1'[C] )
)``````

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Responsive Resident

Create a calculated column on Table1 to create a join to Table2:

Anonymous
Not applicable

Thank you, I thought about it but I would like to do it in DAX.

I dont find the equivalent of MAX for Double, you know when you make column_values = MAX(colum_values_2)

I am looking the equivalent for a String column like

CALCULATE( SUM(table_2[column_F],

table_2[column_D] = table_1[column_A])

or

table_2[column_E] = table_1[column_A] & "_" & table_1[column_C]))

without joining the two tables, just a kind of sumIF

Kind regards

Community Support

Hi @Anonymous ,

You can create a calculated column as below in Table1:

``````Column =
CALCULATE (
SUM ( 'Table2'[F] ),
FILTER ( 'Table2', 'Table2'[E] = 'Table1'[A] & "_" & 'Table1'[C] )
)``````

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors