Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to Solution.
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!