Add column filled with sum from one column based on other column / Power BI
I have a data that looks like this:
I need a formula to add a column and fill a field in the same line, when “Tabelle1.Product” is filled (in Excel IF), it should cumulate “Revenue_Euro” where “sales_acct_unit3” is the same (in Excel SUMIF).
i added a picture in there where you can see the table.
I have the column "“sales_acct_unit3”" which is filled with different values, in my example its "S530". And i need a field filled in an extra coumn in the same row as there a values in the column "Tabelle1.product" having the sum of the column "Revenue_Euro" where all have the same value in "“sales_acct_unit3”"
In that example: In the row where "Sigma" is the value, i want a field next to "Sigma" with the sum of all "S530" fields, because in the row with Sigma the value of “sales_acct_unit3” the value is "S530"