Inserting New Column in Table SUM (UnitPrice) Group By (ReceiptNo) in Transform Data (Power Query)

[MRIZ]

Dear Members, 

I want to add a new column in a factsales table in Power Query which will summerise UnitPrice group by ReceiptNo. 
Below is the actual image:

What I want is new column as shown below:

Thanks. 
Rizwan.

[dufoq3]

Hi @MRIZ, try this:

Result

[MRIZ]

Hi, Thanks for the response and yes it works. What if I want to check some condition like SUM UnitPrice only where RowisActive = 1 Group By ReceiptNo. 

[dufoq3]

Do you mean something like this?

I've added such filter in GroupedRows step.

Result

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTLSszQHUoZKsToQARM9IxMgZQAWMAKrMDSCqzAGsfTMLOECJggVEC2mQJapnqUxXIUpwhagilgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ReceiptNo = _t, UnitPrice = _t, RowisActive = _t]),
    ChangedType = Table.TransformColumnTypes(Source,{{"ReceiptNo", Int64.Type}, {"UnitPrice", type number}, {"RowisActive", Int64.Type}}, "en-US"),
    GroupedRows = Table.Group(ChangedType, {"ReceiptNo"}, {
        {"All", each _, type table [ReceiptNo=nullable number, UnitPrice=nullable number, RowisActive=nullable number]},
        {"SumUnitPrice", each List.Sum([UnitPrice]), type number},
        {"SumUnitPrice RowisActive 1", each List.Sum(Table.SelectRows(_, (x)=> x[RowisActive] = 1)[UnitPrice]), type number}
    }),
    Expanded = Table.ExpandTableColumn(GroupedRows, "All", {"UnitPrice", "RowisActive"}, {"UnitPrice", "RowisActive"})
in
    Expanded

[MRIZ]

So far I followed your solution and its working, but my requirement is more complex. This is what i want to achieve. See this SQL 

CASE WHEN  (IsRefundSaleOrder = 1 AND IsRefund = 0 )  THEN 0
		 WHEN  (IsRefundSaleOrder = 1 AND IsRefund = 1 )  THEN (SELECT SUM(DISTINCT (ROUND([UnitPrice],2)))  
																FROM dw.Fact_Sales a 
																WHERE a.SaleOrderID = sal_ord.SaleOrderId 
																--AND a.SaleOrderItemID = sal_ord.SaleOrderItemID 
																AND a.RowIsActive = 1 AND a.IsRefundSaleOrder = 1 AND a.IsRefund = 1
																GROUP BY a.SaleOrderId)
		  ELSE (SELECT SUM(DISTINCT (ROUND([UnitPrice],2)))  FROM dw.Fact_Sales a 
				 WHERE a.SaleOrderID = sal_ord.SaleOrderId 
				 --AND a.SaleOrderItemID = sal_ord.SaleOrderItemID 
				 AND a.RowIsActive = 1 
				 GROUP BY a.SaleOrderId) 
	END AS SumOfUnitPrices

If you can help in this as this is me first ever M Query. 

thanks.