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.
Please create dummy data that replicates your format and also show your expected results and the logic you applied.
Thank you very much for your reply. I need to add a cloumn which shows the result like in Production day column starting from first sales date as I need to get sales revenue for first 14 days of each product. After getting column or measure result, need to add it as slicer to report so that it could be easier to get the result for all product by slicer for their first 14 days sales revenue.