Re: A ? for a Report: How to Subtract Returned Items Quantities

hidalgo — Sat, 26 May 2018 19:22:18 GMT

kcantor

I created a conditional field as you told me called "Quantity"and it worked thanks. The returns now shows negative quantity.

let
Source = OData.Feed("------"),
#"Post Purchases_table" = Source{[Name="Post Purchases",Signature="table"]}[Data],
#"Added Conditional Column" = Table.AddColumn(#"Post Purchases_table", "Quantity", each if [Type] = "Return" then [ReceiptQty]*-1 else [ReceiptQty])
in
#"Added Conditional Column"

THEN. I tried to create an aditional column called "Qty" for the report to sumarize the Quantities so it could automatically substract those Returns with negative numbers BUT The designer shows the error in the picture below.

How do I create that new Qty column to make it SUM those positive and negative Quantities?

A ? for a Report: How to Subtract Returned Items Quantities

hidalgo — Fri, 25 May 2018 12:39:48 GMT

I have the following Purchasing Query that shows all rows -> purchases Receipts and Returns by Items.

I need to group by Items and sumarize the ReceiptQty. (UnitCost, ExtCost and Volume won't change) BUT first I need to substract the Returned Items ReceiptQty (see the yellow ones) from the Receipts Item ReceiptQty.

How do I do that in Power BI?

Thanks

hidalgo Tracker

Re: A ? for a Report: How to Subtract Returned Items Quantities

A ? for a Report: How to Subtract Returned Items Quantities