Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help Please with Calculated Table Logic

Hi all,   Looking for some help to think through this dax calculation I'm trying to come up with:   I have robot log data based on queues for a couple of months. Each line item is a transaction o...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Maybe I see what you mean. Please try the DAX below.

    Table = 
FILTER('Table (2)',
'Table (2)'[Date]=CALCULATE(MAX('Table (2)'[Date]),ALLEXCEPT('Table (2)','Table (2)'[Key]))
&&CALCULATE(COUNT('Table (2)'[Key]),ALLEXCEPT('Table (2)','Table (2)'[Key]))>1)

     

    For more details, please refer to the sample .pbix.

     

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

please provide some sample data and the expected output. Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Here are all of the relevant fields here. Key, Status, Ended, Exception Reason. For any cases where there are 'Retries' in 'Status' column, that means that there are duplicates in the Key column. I want some sort of outcome like this:

     

     

    So it'll show me any keys that once were retired, it retries the MAX date of all retried cases which tells me what ended up happening int he end. PLease let me know if this is enough information.