DAX ,Find Max

[Nikhil_D]

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.

 

[amitchandak · Accepted solution]

@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())

[Nikhil_D]

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