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.
When you use FILTER over a whole table, the engine has to load the entire table into memory. Your measure was doing this 3 times so that is why you were running out of memory. You should be able to add your column like this.
Column =
CALCULATE (
COUNTROWS ( Task ),
ALL ( Task ),
Task[Date] <= EARLIER ( Task[Date] ),
Task[Task Name] = EARLIER ( Task[Task Name] ),
Task[Index] <= EARLIER ( Task[Index] )
)
Thanks for your reply. But it doesn't give me the separate calculation for each product from 1 (first day of product from each product separately) as I need to show the first True 14 days of each product