Creation of a table with unique values

[Gwen]

[tamerj1 · Accepted solution]

Hi @Gwen 
You can create new table

NewTable =
DISTINCT (
    SELECTCOLUMNS (
        People,
        "ID", People[ID],
        "Name", People[Name],
        "Rank", People[Rank]
    )
)

[Gwen]

cool thank you. have a good day

[Gwen]

So effective... thank you ! 

[tamerj1 · Accepted solution]

Hi @Gwen 
You can create new table

NewTable =
DISTINCT (
    SELECTCOLUMNS (
        People,
        "ID", People[ID],
        "Name", People[Name],
        "Rank", People[Rank]
    )
)

[Gwen]

Can I add a filter? For example I would like to filter the "empty" IDs. Thank you

[tamerj1 · Accepted solution]

 @Gwen yes you can

NewTable =
FILTER (
    DISTINCT (
        SELECTCOLUMNS (
            People,
            "ID", People[ID],
            "Name", People[Name],
            "Rank", People[Rank]
        )
    ),
    [ID] <> BLANK ()
)