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

     

amitchandak's avatar
amitchandak
Super User
5 years ago

hanssonnor , Try a measure like

calculate(lastnonblankvalue('Work Order Time Transactions'[Status], max('Work Order Time Transactions'[Center])),'Work Order Time Transactions'[Reason Code] = "0B")

hanssonnor's avatar
hanssonnor
Frequent Visitor
5 years ago

Hi Amit,

 

thanks a lot,  it works 🙂

 

Best regards

Arne