Forum Discussion

naoyixue1's avatar
naoyixue1
Post Patron
2 years ago
Solved

Using first row as a header issue

Hey there,    I tried to create the report to catch the latest 30 days excel file, which is extracted out of the other planning system. Givne that, individual file will have the name about when t...
Need Help
  • naoyixue1's avatar
    naoyixue1
    2 years ago

    Hey all, thanks. I just figured it out. In this case, I can use the create the conditional column to avoide that issue. Anyway, thank you though. 

     

     

parry2k's avatar
parry2k
Super User
2 years ago

naoyixue1 you will replace the previous step with the previous step name in your M: from your screenshot it looks like it is promoted headers1, so it will be:

 

 #"Renamed Columns" = Table.RenameColumns(#"Promoted Headers1",{{Table.ColumnNames(#"Promoted Headers1"){0}, "New Column Name"}})