Forum Discussion
Load& Combine + Unpivot
hi Team, i have monthly excel files that contains a forecast for some items, each item has a code and descrition. the table i recieve monthly contain first column called "code", second column ca...
camargos88 sorry for bothering alot but you are really helping.
now i applied all the steps until pivoting on the sample file, when i click apply and close for the query, it gives me the error as "column "column3" of the table wasn't found"
I just refreshed the pbix without erros.
Did you change something on the code or excel files ? If yes, maybe it needs some adjustments.
camargos88 thanks a million, a big fat thank you 🙂
i was working on another file which had lots of other equations for the aggregrate query, that was an error from there, removed the step of modifying "column3" then it worked.