Solved: Filter slice with unique rows

Uribe · 03-13-2024 07:14 PM

Hello experts,

I have a table with duplicates in column name and date. I need a slice to remove duplicate rows.

Table with duplicates:

I need the slice to show:

Thanks in advance!

Suvrutt_Gurjar

Please try a slice row filter expression of

[Key Column] =MINROW("Table Name", "_ROWNUMBER", AND([Name]=[_THISROW].[Name] , [Date]=[_THISROW].[Date]))

Suvrutt_Gurjar

Please try a slice row filter expression of

[Key Column] =MINROW("Table Name", "_ROWNUMBER", AND([Name]=[_THISROW].[Name] , [Date]=[_THISROW].[Date]))

Uribe

Thank you so much!

Suvrutt_Gurjar

You are welcome.