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.
If you don't add 1 then the first day of the production will return 0 since the date on the row and the first date will be the same.
Thank you vey much! Apperciate you for your assistance.
