Expression.Error: We cannot convert the value "" to type List.

Hi Anonymous ,

Table.FromColumns requires a list as it's first parameter https://docs.microsoft.com/en-us/powerquery-m/table-fromcolumns

In this case it should be a list of columns from another table but somewhere in your formula you have values which is why you are getting this error.

I notice that some of the column names in your formula begin #" , are these actually table columns? Can you confirm all the columns you are feeding into Table.FromColumsn exist because I can see the column named BT Online Share YOY% but in the formula the name is #"BT Online Share YOY%".

Did you select all the columns using the GUI?

Phil

If I answered your question please mark my post as the solution.

If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

Hello Anonymous 

I see that you are using this function in a new column. So as long you cell value are not lists, you are referencing here a scalar value, but you need lists. What I don't get... why you are trying to create a table out of table, using Table.FromColumns? You should just remove columns or select columns from your current table.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy