Forum Discussion

webportal's avatar
webportal
Impactful Individual
10 years ago
Solved

Split column in two

Hello,

 

My table has the following structure:

I need to analyse the variance of views by page title from the periods in column B: 2016 vs 2015.

For that, I'm using Power BI desktop. I'm trying to split column B in two: one with the period 1/jan/2015-19/ago/2015 and other with 1/jan/2015-19/ago/2015

 

Is this possible to do? How?
I tried unpivoting but it didn't work.

 

Thanks in advance for helping!

Need Help

2 Replies

    • webportal's avatar
      webportal
      Impactful Individual
      10 years ago

      Hi,

      Pivot is the word indeed (not split).

      However, I have other values columns, like time on page, bounce rate, etc.

      After pivotting the column, the table becomes a mess...

      Perhaps I should go back to Excel, build a pivot table and copy-paste values to another table.

      Or is there a way to pivot a column with multiple value columns?

      Thanks for helping!