Expression Error Due to new column added in report

[srehman]

Hi Team,

I am downloading all csv files in folder. From this (Consolidated) Folder all reports exporting in power query and performing all task perfectly.

Now due to new update there is 1 more column added Before ( Date Time in single column). now date & Time in 2 separate columns.

I am facing expression error.

Any help

 

[alansidman]

This link may be helpful. Finding mismatched headers and creating a conversion table - Bonus Exercise - Chapter 4 - #PowerQuery Book - DataChant

 

[srehman]

Thanks Alan,
It does work in my scenario but i had performed some more steps according to my query which already a combination of many steps.
Would you please share some free pdf books or blogs links where i can learn more about daily troubleshooting in more professional way like as above link.
Thanks again.

 

[alansidman]

I use Google to search for issues. I don't have a repertoire of help locations. A book that I used to get me started "M is for (Data) Monkey" by Ken Puls and Miguel Escobar. A second book I have is "Collect, Combine, and Transform Data Using Power Query in Excel and Power BI" by Gil Raviv. Both are available on Amazon and are worth the money if PQ is something you want to learn more about.

 

[srehman]

Yes sure i will buy it. Thanks