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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous 
Are you expecting something like this?

 

 

 

Paul Zheng _ Community Support Tea

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous I think this might work for small data.

    For large data the nested IF with be very lengthy.

     

    This solves my problem. I have to create a big DAX for it!

     

    Thanks.