Fetching row values

[Anonymous]

Hi,

I need to fetch the Start Date and End date values highlighted shown below. I need a measure/calculated column based on a status column.

For Ref No 101 I need to fetch the start date for status = Submitted

and End date for status = Approved

Result expected :

Regards,
Ashfiya

[Jayee · Accepted solution]

Hi @Anonymous ,

Try below measures with Ref No

Start Date = calculate(min(table[start date]), all(table[start date]),status="Submitted")

End Date = calculate(max(table[end date]), all(table[end date]),status="Approved")

 If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!