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.

AnushaSri's avatar
AnushaSri
Resolver II
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.

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?