Forum Discussion
Power BI formula needed
Please help in calculating the Day Level Order Balance Qty Note - Data is shorted by Order Date first then Order Qunatity Material_Location_Order Booked Date Location Material Order Quanti...
You will need to add an index column if you want it to be evaluated for each row. We cannot use the order date and quantity column as the values repeat. And also, with that much row, I dont think a calculated column is a good option - it's computationally expensive.
Material_Location_Order Booked Date is the key that I want to use to calculate the Day Level Order Balance Qty in Power BI not in Power Query