So, I have the following tables

transactions = [date], errorID, status
calendar = [date], year, month etc .

The critical field here is errorID.
Maybe the best way to illustrate the raw transaction data is by example :

I now need to create a report to show the AGE of errors.
age1 = days since first occurrence
age2 = days since last 'Repeat' status

To keep things simple (I thought !)
... I tried to ignore AGE for now, and just see if I could get the correct earliest date to show for each errorID.

Yet I am so confused - must be missing some key concepts here.
How to do a MIN on date, ignoring all row context apart from keeping my errorID !!?!

Hope someone can point me in the right direction !
Many Thanks

Typical !

Spend 6 hours not finding an answer, then post the Question, and 5 minutes later you find the answer.

=calculate(min(transactions[Date]),ALLEXCEPT(transactions,transactions[errID]))

• Marked as answer by SimonB2013 14 hours 43 minutes ago

Hi Simon,

Glad to hear that your issue had been solved by yourself, thank you for your sharing which will help others who have the similar issue.

Regards,