Solved: How to use unique? - Page 2

Eduardo_dos_San · 01-11-2020 10:46 AM

I have a “company” column in a table.
In the column there are several rows as the name of the same company.
I would like to create a UX where only show the name of these companies once.

I tried

unique(list (table [company]))

in the slice.

DOES NOT WORK

Any tips?

Bellave_Jayaram

I wouldn’t recommend using RowNumber as it may not reflect the true chronological order of the rows. Use a time stamp instead and define a yes/no VC in your table like this:

[Timestamp] = MAX(SELECT (Table [Timestamp], [Company]= [_THISROW]. [Conpany]))

Then you can display rows based on that VC being TRUE.

View solution in original post