Forum Discussion
Power BI formula needed
Thank you Ryan
Data set is huge around 11-13 lakh row, is there any way I can get the same result without using the Index
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.