Dax logic

[jimpatel]

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?

[jimpatel]

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

[Dangar332 · Accepted solution]

hi, @jimpatel 

you can download .pbix file click HERE 

version

[jimpatel]

Perfect

Thanks a lot for your help 

Appreciated

[jimpatel]

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]

hi, @jimpatel 

try below measure

measure =
calculate(
   max(table[date]),
   allexcept(table,table[ordernumber],table[operation])
)

[jimpatel]

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

Thanks

[Dangar332]

hi, @jimpatel  

from above your data

try below measure

var a = 
CALCULATE(MAX(jim[date]),ALLEXCEPT(jim,jim[order nu],jim[opeartion])) 
RETURN
MAXX( FILTER(jim,jim[date]=a),jim[date])

[Dangar332]

hi, @jimpatel 

provide real time data with removing confidential information

[jimpatel]

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

[Dangar332]

hi, @jimpatel 

 copy and paste your above data here in table form to look over

[Greg_Deckler]

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