Forum Discussion

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...

Super User

2 years ago

To get a new column for the next phase time:

next start = CALCULATE(MIN('Table'[Start]), REMOVEFILTERS('Table'[Start]), 'Table'[Start] > EARLIER('Table'[Start]))

Anonymous

Not applicable

2 years ago

Hi,

I get a circular dependency error when I tried this! Any ideas?

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
  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
    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

Related content