Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Grouping one value in two groups

I am trying to group data of a column. I want to group one value in two groups, how to do it?   For Example:  I am creating new column of group called Z. The column has multiple cities name of USA....
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Anonymous 
    Are you expecting something like this?

     

     

     

    Paul Zheng _ Community Support Tea

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You can have comma separated.

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

amitchandak Sorry dear all the data is sensitive can't share.

 

And how to separate it with comma? Can you please help with this?