Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks vicky_ for your concern about this thread.

 

Anonymous If you want a calculated column, you can modify your formula like below. This should work. 

phase end date = 
VAR CurrentID = 'Table'[ID] 
VAR CurrentDate = 'Table'[Phase Start]
VAR PhaseEndDate = CALCULATE(     
    MIN('Table'[Phase Start]),     
    FILTER('Table', 'Table'[ID] = CurrentID && 'Table'[Phase Start] > CurrentDate) ) 
RETURN PhaseEndDate

 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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