Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there
I am using Power query to transform a data set of different products (various alcohol brands). However, Column 4 has 2 unique data sets: 1) Various Quarters in 2019, 2) Numerical Sales Margin by qtr.
How can I split Column 4 into rows that will split both the various quarters in 2019 (Q1 2019, Q2 2019, etc) and 2) the margin ##'s into it's own separate column. Please see 2 screenshow below. the first screenshot shows the end desired result while The second screenshot shows what the original stock data set looks like. Thank you. I just need to know how to split the Column 4, I can figure everything else myself
Solved! Go to Solution.
1. Split column4 by delimiter
2. select columns 1,2 and 3, and then "unpivot other columns"
3. cleanup your headers
1. Split column4 by delimiter
2. select columns 1,2 and 3, and then "unpivot other columns"
3. cleanup your headers
yes. this works perfectly!!. thx