Forum Discussion
Advocate IIUnpivoting Causing values with the same name to become numbered
Hi there,
I am working with an excel document which is structured slightly awkwardly for powerbi, that bieng it has double headers. I've followed the steps in the following video:
Dealing with DOUBLE HEADERS in Power BI using UNPIVOT, TRANSPOSE, and FILL DOWN - YouTube
Follwoing these steps it is almost perfect to working, however values with the same name which are the same have been numbered. I think this stems from them being made colom headers, and these not being able to be the same are then numbered. However, when I then unpivot values are then changed to the example format
Example
Example_45
Example_89
Is there a way to stop this from happening?
As is often the case with powerbi I have managed to solve my issue, by extracting the text before the delimiter, with that being _ only the values original name is kept.
2 Replies
- serpiva64
Solution Sage
Please, can you post some sample data or a imagine of the data, what you obtain and what you need?
JordanJacksonAs is often the case with powerbi I have managed to solve my issue, by extracting the text before the delimiter, with that being _ only the values original name is kept.
