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...
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
Super User
Super UserYour 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.