Add column with a measure or DAX?

Hi KGOLSEN ,

i am assuming you can't also add a calculated column as it's connected to another dataset. If you can create a calculated column then it's better you group there.

You can create a measure to do what you want, but you will not be able to use it in a slicer (though you can use it to filter an individual visualation in the filter pane) or on any axis/legend. I have set up this scenario before this way:

1. Create a measure to sort the column into groups

1. And at this point you realize you can't use it as an axis. So you have to make each measure filtered.

Then you can add them each in on the values section of a visual.

The cleanest I can think of then is using SWITCH, something like this.

Column = 
SWITCH(
    'Table'[ID],
    1234,"Group 2",
    2345,"Group 3",
    3456,"Group 4",
    4567,"Group 5",
    5678,"Group 6",
    6789,"Group 7",
    7900,"Group 8",
    9011,"Group 9"
)