Forum Discussion

pmadam's avatar
pmadam
Helper II
6 years ago
Solved

DAX Help

From below screenshot how do i get  col_orderstatus of max col_orderid number for same col_tnumber     Thanks, Prathy
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi pmadam ,

     

    Please try the below measure, it works on my desktop:

     

     

    CALCULATE(MAX('Table (5)'[Status]),FILTER('Table (5)','Table (5)'[Orderid] = CALCULATE(MAX('Table (5)'[Orderid]),ALLEXCEPT('Table (5)','Table (5)'[Number]))))

     

     

     

    Aiolos Zhao

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi pmadam ,

 

Please try the below measure, it works on my desktop:

 

 

CALCULATE(MAX('Table (5)'[Status]),FILTER('Table (5)','Table (5)'[Orderid] = CALCULATE(MAX('Table (5)'[Orderid]),ALLEXCEPT('Table (5)','Table (5)'[Number]))))

 

 

 

Aiolos Zhao