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

Sorry, I should have been more specific...Please provide sample data in table format (as in data). We cannot work on an image. Thanks!

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Will a CSV file work?

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    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.