Forum Discussion
Not enough memory to complete this operation
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 share some sample data and your expected results. Take a look at this post about how to provide sample data.
Due to the privacy, I am unable to share the details of file. I can bring an example as :
There are 6 products in product column and there are some subproducts of these products in another column (for example product is pen and different pens with different colors, but need to make calculation on products). There are duplicated dates and products as different subproducts were produced and sold, but the name of product is same at product column (task name column) as this subproduct's main box. The starting production date is different for all of these products. I should add a slicer as 1-14 which shows first True 14 days of each product from its production date (ignoring subproduct as need to make calculation for product column).
