Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Data filtering based on higher value in column

Hello all,   I would like to filter the table below based on the higher value in the Order ID for each row where the Unique ID is matching. The table below represents a history that's why there is...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Create a new table with the following filter:

    Filtered Order Table = 

FILTER(
    Table2,
    var __maxorder = CALCULATE( MAX(Table2[Order ID]) , ALLEXCEPT( Table2 , Table2[AA ID] )) return
    Table2[Order ID] = __maxorder
)

     

     



Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

Anonymous 

Create a new table with the following filter:

Filtered Order Table = 

FILTER(
    Table2,
    var __maxorder = CALCULATE( MAX(Table2[Order ID]) , ALLEXCEPT( Table2 , Table2[AA ID] )) return
    Table2[Order ID] = __maxorder
)

 

 



Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you, that works perfectly.