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...
danextian
Super User
Super UserYou 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
- danextian
Your sample data has repeating values for those columns so if the calculation were to be for each row in the sample data, there needs to be a column that identifies the row thus the use of an index column. But even if there already is an index column, creating a calculated column with that much rows would be computationally expensive.