Forum Discussion

Cilliann's avatar
Cilliann
New Member
2 years ago
Solved

Splitting a column

Hello,   I know the answer might be simple, but I am a relatively new Power BI user. I need to split Column1 into two columns to have Date and Accepted as separate columns. Not sure how to achieve ...
Need Help
  • AnushaSri's avatar
    AnushaSri
    2 years ago

    Hi Cilliann 

    There must be another column like ID column to related date and accepted values together like this 

    if yes, then go to power query and to the table, select column1 and go to transform and click on pivot column like this 

    then select coloumn2 in the Values Column and go to advance options and select don't aggregate. 

    Press ok to see the transformed result as below 

    Hope it resolves your isssue.

    Please accept this as a solution, if it resolve your issue. Also please give me kudos.

    Thanks in advance.

justlearning50's avatar
justlearning50
Helper I
2 years ago

Hi Cilliann ,

In edit query, select the query you are interested in, then select Transform>Transpose (to change columns to rows)> (may need Reverse rows) > Home>Use first row as header to get Date and Accepted as the header. 

Hope this works for you. 

  • Cilliann's avatar
    Cilliann
    New Member
    2 years ago

    Hi,

     

    Sorry, if I expressed myself unclearly, I am attaching a screenshot of what I am trying to achieve eventually:

     

     

    Can you please help?