topic Re: SUMIFS in Power BI in DAX Commands and Tips

SUMIFS in Power BI

StefanBG — Tue, 18 Oct 2022 15:17:59 GMT

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!

Re: SUMIFS in Power BI

amitchandak — Tue, 18 Oct 2022 17:46:15 GMT

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.

Re: SUMIFS in Power BI

StefanBG — Wed, 19 Oct 2022 15:08:53 GMT

Thank you for the help!

Stefan