locked
Date since value first appeared (age) RRS feed

  • Question

  • 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

    Monday, September 14, 2015 3:34 PM

Answers

  • 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 Monday, September 14, 2015 4:21 PM
    Monday, September 14, 2015 4:21 PM

All replies

  • 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 Monday, September 14, 2015 4:21 PM
    Monday, September 14, 2015 4:21 PM
  • 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,


    Charlie Liao
    TechNet Community Support

    Tuesday, September 15, 2015 1:01 AM