Forum Discussion
How do I create a new table with distinct values from an existing table?
Hi, hoping someone can help. I need to create a new table which contains the distinct values from another table. I know how to do this using when creating a new table in the table view, but (unl...
Hi RFJammer ,
| Type |
| White British |
| White British Welsh |
| White British Welsh |
| White Scottish |
| White Scottish |
| British White |
| British White |
| White Americans |
| White Americans |
| American Indian |
You can just create a calculate table use follwing code
Table 2 = VALUES('Table'[Type])Create a calculate column
Category =
SWITCH(
TRUE(),
'Table 2'[Type] IN {"White British","White British Welsh","White Scottish","British White"}, "White British",
'Table 2'[Type] IN {"White Americans","American Indian"},"American"
)Final output
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly