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.
Hey,
I have a table with several column named like this "COLUMN_NAME YEAR-MONTH", i want to create two separate columns, "COLUMN_NAME" and "YEAR-MONTH" here's an example :
CM 2019-01 | CM 2019-02 |
232.232 | 9123.222 |
I want to make it like this :
Column_name | date | value |
CM | 2019-01 | 232.232 |
CM | 2019-02 | 9123.222 |
Is there anyway i can achieve that with power query?
Regards
Solved! Go to Solution.
Try Transpose first, then you can split your columns using the built in features of powerquery, perhaps use add column from examples to make the process even easier
You need to transpose first. Refer :https://radacad.com/pivot-and-unpivot-with-power-bi
Try Transpose first, then you can split your columns using the built in features of powerquery, perhaps use add column from examples to make the process even easier
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |