Forum Discussion
Solved
Power Querry value stored as Table
Hello, I'm really struggling with one column. I imported data through the API, and some rows have the value visible, while others can be seen as a Table. I know that the correct value is present ...
Hello, @Ints. If table consists of single row and column the try this:
Table.AddColumn( Source, "new_column_name", (x) => try Table.FirstValue(x[data_column_name]) otherwise x[data_column_name] )
I found my mistake and now its worked. Thank you very much!!