Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Table creating with no repetition

I have a table like that:

id_name, name

1, name1

1,name1

1,name1

1,name1

2,name2

2,name2

3,name3

3,name3

3,name3

 

How can I create a table with no repetition, like:

id_name, name

1, name1

2,name2

3,name3

 

Thanks,

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hey Anonymous

     

    You can create a calculated table and give it the following code:

     

    New Table = 
SUMMARIZE(
    Table1,
    Table1[id_name],
    Table1[name]
)

    Hope this helps,

    Parker

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey Anonymous

     

    You can create a calculated table and give it the following code:

     

    New Table = 
SUMMARIZE(
    Table1,
    Table1[id_name],
    Table1[name]
)

    Hope this helps,

    Parker