Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 ...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

I don't think that ultimately matters because to perform any further analysis, you will need to "unpivot Other columns" to get all dates in a single column.  

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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