DAX: Min(Start_date) based on previous date

Question

Please lend your hand to resolve my issue facing in DAX logic.

Table

I need

I don't know how to proceed with Dax could you please share me your ideas

Edit2: What if my data is like this Batches -B will start on day 1 and complete on next day

Thank you for reading. BI_seeker

Answer 1

Here you go :

Min_Start_Date = CALCULATE(MIN('Table'[Start_Date]),FILTER('Table','Table'[Batches] = EARLIER('Table'[Batches])))

Max_End_Date = CALCULATE(MAX('Table'[End_Date]),FILTER('Table','Table'[Batches] = EARLIER('Table'[Batches])))

Hope this solves your query