Forum Discussion

jimpatel's avatar
jimpatel
Post 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 example with specific number in column 1 which is ordernumber in this instance. I would like to do

  a. Check column 3 against same number in column 1 and look for latest date in column 6. 

The idea is instead of several rows, i am trying to condense to one row for 0030 and one row for 0020 and so on.

 

In this example what i am expecting is  to show very first row as the result and rest of them can be deleted for 0030. For 0020 same as well.

 

Any idea please?

Help

11 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    2 years ago

    jimpatel If you put Column1 and Column3 in a table visual, then just use a measure for MAX('Table',[Column6]).

  • jimpatel's avatar
    jimpatel
    Post Patron
    2 years ago

    Thanks a lot for your reply. In this instance i am getting 16 January 2024 as the answer. But i am looking for 16th jan for 0030 and 9th jan for 0020 and so on please

     

    Thanks a lot and much appreciated

  • jimpatel's avatar
    jimpatel
    Post 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
      Resident Rockstar
      2 years ago

      hi, jimpatel 

      try below measure

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

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

         

         

         

        Thanks

         

         

  • jimpatel's avatar
    jimpatel
    Post Patron
    2 years ago

    Hi

     

    Thanks a lot for your reply 

     

    Is it possible to share BI version of above please? For some reason the above formula does not work for me and i can check with your file where i went wrong please

     

    thanks a lot 

    much appreciated