Calculated Column

[Afiq_Danial]

Hi, I'm still new to DAX and Power BI. I need help creating the 2 new columns. I want to have a table like this:

The table that I have right now looks something like this:

Note: I can't use PQ as it will affect my other datas. I have to create the 2 new columns.

Thank you very much!

[amitchandak · Accepted solution]

@Afiq_Danial , New column in DAX

New start Date = minx(filter(Table, [Job Name] = earlier([Job Name]) ), [Start Date])

New end Date = Maxx(filter(Table, [Job Name] = earlier([Job Name]) ), [end Date])

[Afiq_Danial]

Thank you! Appreciate it