Forum Discussion
Promoted Headers Date leading zeros Problem
I encountered a problem in the power query when I tried to promote the first row with a Date data as my header. Once it promoted to a header, leading zeros appeared in the headers. How can I disable ...
I dont need to unpivot other columns since under these dates are currencies for different projects. The problem is the changing of the data format once it had been promoted as a header.
Hi Anonymous,
Can you please share some dummy data that keep the raw data structure? It should help us clarify your scenario and test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng