topic Re: DAX ,Find Max in DAX Commands and Tips

DAX ,Find Max

Nikhil_D — Fri, 09 Jul 2021 08:44:46 GMT

Hello! I have a problem and have a feeling a simple DAX formula can solve it.

I would like the 'Output' column to be created with 'Seconds' column.

For PID 3 , Seconds are repeated and I need Only one entry in "Output" Column and for PID 2, I need only Max Seconds.

Re: DAX ,Find Max

amitchandak — Fri, 09 Jul 2021 17:37:57 GMT

Nikhil_D , You need to add an index column in power query

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

then try Dax formula

output = var _1 = maxx(filter(Table, [pid] = earlier([pid])), [second])
return
if([index] = maxx(filter(Table, [pid] = earlier([pid]) && [second] =_1), [index]) , [second], blank())

Re: DAX ,Find Max

Nikhil_D — Fri, 09 Jul 2021 18:53:18 GMT

Hi amitchandak ,

Thanks for your answer. I followed u r steps but didn't get solution.

I think I have not explained clearly.

So let me tell u clearly.

I have tabel as below mentioned and I need "Output" Column.

PID Column have Duplicates and I can not remove those duplicates. I need those for another purpose.

What I need is Calcute P_Second based on PID.

If P_Seconds are Unique for PID, I need only one entry in 'Output' column.

If it is not Unique and I need Max Secons in 'output' column.

if PID is Null, I need it Null only.

Thanks