topic Re: Dax logic in DAX Commands and Tips

Dax logic

jimpatel — Tue, 16 Jan 2024 16:05:29 GMT

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?

Re: Dax logic

Greg_Deckler — Tue, 16 Jan 2024 16:35:02 GMT

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

Re: Dax logic

jimpatel — Tue, 16 Jan 2024 16:43:32 GMT

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

Re: Dax logic

Dangar332 — Tue, 16 Jan 2024 17:49:16 GMT

hi, jimpatel

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

Re: Dax logic

jimpatel — Tue, 16 Jan 2024 17:56:22 GMT

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

Re: Dax logic

Dangar332 — Tue, 16 Jan 2024 18:27:15 GMT

hi, jimpatel

try below measure

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

Re: Dax logic

jimpatel — Tue, 16 Jan 2024 18:36:04 GMT

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

Thanks

Re: Dax logic

Dangar332 — Tue, 16 Jan 2024 18:41:35 GMT

hi, jimpatel

provide real time data with removing confidential information

Re: Dax logic

Dangar332 — Tue, 16 Jan 2024 18:51:35 GMT

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])

Re: Dax logic

jimpatel — Wed, 17 Jan 2024 08:49:10 GMT

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

Re: Dax logic

Dangar332 — Wed, 17 Jan 2024 09:07:57 GMT

hi, jimpatel

you can download .pbix file click HERE

version

Re: Dax logic

jimpatel — Wed, 17 Jan 2024 11:12:15 GMT

Perfect

Thanks a lot for your help

Appreciated