Forum Discussion
Find next start date in table
Hello everyone, I have a table that looks like the following: An ID field, a phase, and the date the item was put in that phase (or the phase start date). I want to add a column that finds...
This worked great on my dummy data (thank you!) but when I do it on my real, much larger dataset I get this error:
There's not enough memory to complete this operation. Please try again later when there may be more memory available.
Any ideas how to make it more memory efficient?
Hi Anonymous
Not sure if this would be more efficient, you may give it a try:
phase end date =
VAR CurrentPhase = 'Table'[Phase]
RETURN
CALCULATE(MIN('Table'[Phase Start]),ALLEXCEPT('Table','Table'[ID]),'Table'[Phase]>CurrentPhase)
Best Regards,
Jing