Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

FilteredTable placement

It as suggested that I use the following filter to remove dupicates from my tabel. Can someone tell me where I should place this funtion? At the query leve or the calculated column level?

 

FilteredTable =

FILTER(YourTable, YourTable[Col2] = MAX(YourTable[Col2]))

 

Thanks

Need Help

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    1 year ago

    Anonymous it will be easier if you provide details of what you are trying to achieve and share sample data with the expected output.