Forum Discussion
Solved
Not enough memory to complete this operation
I wanted to created a new column to get numbers per product depending on date column in Power BI Desktop but it gives error not enough memory to complete this operation. I have also replaced EARLIER(...
For that we just need to find the lowest date for the product and comare that to the date of the row.
This would be adding a calcualted column to your table.
Production Day = VAR _ProdStart = CALCULATE ( MIN ( 'YourTable'[Date] ), ALLEXCEPT ( 'YourTable', 'YourTable'[Product] ) ) RETURN 'YourTable'[Date] - _ProdStart + 1I have attached my sample file for you to look at.
For that we just need to find the lowest date for the product and comare that to the date of the row.
This would be adding a calcualted column to your table.
Production Day =
VAR _ProdStart = CALCULATE ( MIN ( 'YourTable'[Date] ), ALLEXCEPT ( 'YourTable', 'YourTable'[Product] ) )
RETURN 'YourTable'[Date] - _ProdStart + 1
I have attached my sample file for you to look at.
Hi Jdbuchanan,
Thank you very much for your assistance and guidance. That was well worked, but 1 more thing I would like to clarify with you: why did you add 1 to calculation at last step?
