Hello and thank you for reading.
I'm working on a master rollup assignment for a construction company. The goal is to have individual workbooks for specific jobs that feed into a master rollup for various items like change orders.
I'm encountering an issue in power query where a column with text from certain workbooks throws the error
"DataFormat.Error: We couldn't convert to Number. Details: Supply Access Control Items (Keypads And Handicap Push Buttons)"
with "supply Access...." being the data I am trying to get into the rollup.
I converted the data type to text in the query and I still get the error about converting to a number. I have experimented with changing the actual data from the individual job sheet with no success. Any thoughts on a path forward would be much appreciated.
Bookmarks