Forum Discussion
DAX ,Find Max
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.
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())
2 Replies
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())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
