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
vicky_'s avatar
vicky_
Icon for Super User rankSuper 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's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

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

     

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