Power query adding expandable year column

0
votes

I have created a custom column and I want this column to be expandable. How do I make it expandable?

enter image description here

and when I click on the error in the image it shows the below error

**Expression.Error: We cannot convert a value of type Table to type Function.

Details: Value=Table Type=Type**

Thank you

1
powerbi

1 Answers

1
votes

TransformColumns() is your friend.

As BICCOUNTANT showed us, you can use this to expand columns

Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type list) then _ else {_} }} )

tables

Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type table) then _ else #table({“Column1”}, {{_}} ) }} )

and lists

Table.TransformColumns(Source, {{“Column1”, each if Value.Is(_, type record) then _ else [a=_] }} )