SUMIFS in Power BI

[StefanBG]

Hi,

Have two tables, want to add column in table 1 based on SUM from a column in table 2.

The column must SUMIFS like excel based on the same row in table 1 and columns in table 2.

Like SUMIFS(Result Column Table 2, Column 1 in Table 2 = value in row in Column 1 in table 1, Column 2 in Table 2 = value in row in Column 2 in table 1, Column 3 in Table 2 = value in row in Column 3 in table 1)

So it sums the column from table 2 based on only the rows where these three matches,

So on the row it sums if the Date matches, the Unit matches and the Name matches. A normal SUMIFS with different tables.

Have tried SUMX, Calculate with SUM and filters but can't get it right. Closest is that it equals a specific value, but I want it to equal the value in the row.

Could you please help me solve this?

Thanks!

[amitchandak · Accepted solution]

@StefanBG ,

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[StefanBG]

Thank you for the help!

Stefan