Forum Discussion
Fetching row values
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
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!!
1 Reply
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!!