Forum Discussion

integracaoti's avatar
integracaoti
Frequent Visitor
5 years ago
Solved

Create End Date Based on Next Task Start Date

Hi,   I'm a new Power BI user and I have the situation below (around 500+ rows and it continually grows). Each Identification represents a different company (it's a registration ID), and every tim...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    Does this calculated column formula work?

    endDateRelatedNextTask = CALCULATE(MIN(eventos[dataInicio]),FILTER(eventos,eventos[Identification] = EARLIER(eventos[Identification]) && eventos[dataInicio] > EARLIER(eventos[dataInicio])))

    Hope this helps.

integracaoti's avatar
integracaoti
Frequent Visitor
5 years ago

Ashish_Mathuryour formula worked LIKE A CHARM! Thank you so much, with your help I even managed to make more complex visualizations.

I'm also thumbing up StefanoGrimaldi and MattAllington because you guys helped me with other stuff as well! Thank you very much for your time!

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    You are welcome.