Calculated Column

[Anonymous]

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]

@Anonymous , 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])

[Anonymous]

Thank you! Appreciate it