Hi, I have the requirement where I need to convert the multiple columns into single month column. Please see the below excel.
This is how I want it.
please help. Crosstable layout ?
Go to Solution.
Hey @rbangari001 ,
this is my sample data:
The task you have to solve is converting a table from the wide format into a table in the long format, meaning converting columns into rows.
For this reason, I mark all columns (in my example it's just the column this or that), except the columns ForecastValue_... and select the operation from the context menu Unpivot Other Columns:
The next picture shows the result of the operation:
Then I split the column now called Attribute, rename the columns accordingly and delete the column that contains the characters fc or ForecastValue respectively.
Hopefully, this provides what you are looking for.
View solution in original post
Thank you, it worked
Check out the News & Announcements to learn more.
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!