Forum Discussion

jamienourish's avatar
jamienourish
Frequent Visitor
6 years ago
Solved

Rearrange a delimited string

I have a column with the string "morning, evening, afternoon"   I need this as a string but in the order "morning, afternoon, evening"   How can I do this withing PowerBi? Is there a way I can ma...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi jamienourish 

    Situation1:

    In Edit queries, add a custom column

     

    Situation 2:

    In Edit queries, Create a conditional column

     

    Close&&apply

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi jamienourish 

sure please see the attached file with the solution.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

jamienourish's avatar
jamienourish
Frequent Visitor
6 years ago

Thank you,

 

I seem to be having a problem doing this with direct query. any ideas?

  • mussaenda's avatar
    mussaenda
    Community Champion
    6 years ago

     

    Unfortunately you cannot use these steps for direct query.

    Don't know how to help. Sorry.

    Mariuszmight help you.

     

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi jamienourish 

       

      To make it work for the direct query you can create a table like below and create a relationship on 'Table A'[Text] and 'Table B'[In] and use "Out" column in your reports.

      Table B = 
ADDCOLUMNS(
    ROW( "In", "morning, evening, afternoon" ),
    "Out", "morning, afternoon, evening"
)

      Or change the order at the source

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      Mariusz Repczynski