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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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.