Forum Discussion

hanssonnor's avatar
hanssonnor
Frequent Visitor
5 years ago
Solved

Problem MAXX function with string

Hi,   I am currently working on a measure using the following table:   Number Item Reason Code Status Center 60607788 abc 0B 10 G1A30 60607788 abc 0B 20 G1G30 60607788 ab...
  • hanssonnor's avatar
    hanssonnor
    5 years ago

    Hi Amit,

     

    thanks a lot,  it works 🙂

     

    Best regards

    Arne

     

hanssonnor's avatar
hanssonnor
Frequent Visitor
5 years ago

Hi Colacan,

 

thanks for your approach. I had to modify it though, with the Allexcept it did not work. However once I removed that filter it showed the same results.

 

Best regards

Hansson

colacan's avatar
colacan
Resolver II
5 years ago

hanssonnor  Hi Hanssonnor, I have noticed that extracting highest or lowest recode within categories is quite tipical problem which lots of people are facing. And Allexcept function is quite useful for those problems.

Cheers!