Forum Discussion
Subtracting rows
Hi folks, I'm new here and quite new to power BI. I have two tables: 1. Items with purchase date & Quantity ItemNo PurchaseDate Quantity Index 854 20/03/2019 32 2 854 30/04/...
Hi,
How have you arrived at the numbers in the Balance column? What is the logic?
SUM of Quantity minus Forecast = Balance is my logic, but it would only work if the table was grouped by item.
