Forum Discussion
Arnault_
Resolver III
Resolver IIIFilter / Summarize Table by Max Value index
Hi All, I have one table with duplicated rows. I would like to remove these duplicates. It can be achieved by using one column and keeping the highest index. Here is a simple example. For each perio...
Arnault_ ,
You can create a flag column new column
=
var _max - maxx(filter(Table, [Period] = earlier([Period]) && [item] = earlier([item] ) ) , [category_index] )
return
if([category_index] =_max, false(), true())
amitchandak
Super User
Super UserArnault_ ,
You can create a flag column new column
=
var _max - maxx(filter(Table, [Period] = earlier([Period]) && [item] = earlier([item] ) ) , [category_index] )
return
if([category_index] =_max, false(), true())
Arnault_Resolver III
Resolver IIIThanks for your ansnwer.
I actually created 2 columns applying the same logic:
Max_index = CALCULATE ( MAX ( Table_test[category_index] ),
ALLEXCEPT ( Table_test, Table_test[item],Table_test[Period] )
)
Max_Index_YorN =
If ( Table_test[Max_index] = Table_test[category_index], 1, 0 )