Forum Discussion

jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
2 years ago
Solved

Dax logic

Hi,   Thanks for looking at my post.   I have table which having several rows of data. Is there any possibility to do the below logic please?   1. With table below, I have given one examp...
Help
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, jimpatel 

    you can download .pbix file click HERE 

     

    version

     

jimpatel's avatar
jimpatel
Icon for Post Patron rankPost Patron
2 years ago

Thanks a lot for your reply.

 

In this instance i am expecting only highlighted row to show please as those are the latest date for respective operation and order number

 

 

Thanks a lot

  • Dangar332's avatar
    Dangar332
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    hi, jimpatel 

    try below measure

    measure =
calculate(
   max(table[date]),
   allexcept(table,table[ordernumber],table[operation])
)
    • jimpatel's avatar
      jimpatel
      Icon for Post Patron rankPost Patron
      2 years ago

      Thanks a lot for your reply.  Unfortunately, this is still showing duplicates

       

       

       

      Thanks

       

       

      • Dangar332's avatar
        Dangar332
        Icon for Resident Rockstar rankResident Rockstar
        2 years ago

        hi, jimpatel 

        provide real time data with removing confidential information