Create new column with different criteria: SUMIFS in excel

[usu123ario]

Hello, 

I would like to add a column using the excel formula: =SUMIFS(sum_range, criteria_range1,criteria1,criteria_range2_criteria2) in power bi.

I need to implement Column D into into power bi (new column).

A	B	C	D
Order Number	Order Number Line	Units	Value
A	1	10	55
B	1	27	97
C	1	34	45
B	2	70	97
A	2	45	55
C	2	7	45
C	3	4	45

In this new column I would like to add the number of total units for each order number (result column D) and to return the result of the sum in each row corresponding to that order number.

Thank you

[dharmendars007 · Accepted solution]

Hello @usu123ario , 

Pleae use the beloe logic you should be able to get the values you are expecting..

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN