Forum Discussion

AlessandroBet's avatar
AlessandroBet
Icon for Helper V rankHelper V
7 years ago
Solved

Creating a new group with DAX

Hi,

 

i'm getting data from dataset so i can create new new group field. Can i do it working with DAX?

 

thanks

Need Help
  • tex628's avatar
    tex628
    7 years ago

    It's not possible to do with a measure. 

11 Replies

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Can you provide an example of the desired outcome? 

    • AlessandroBet's avatar
      AlessandroBet
      Icon for Helper V rankHelper V
      7 years ago

      I have a list of strings inside a field:

      DN_AD

      DS_AD

      DW_AD

      DN_AA

      DS_AA

      DW_AA

      ...etc

       

      As you can see the first 3 end with AD and the last 3 with AA

      I would like group named "AD" with the following string

      - DN_AD

      - DS_AD

      - DW_AD

      and a group named "AA" with the following string

      - DN_AA

      - DS_AA

      - DW_AA

       

      I hope this can help you understand what i need