Power Query: Issue with adding lists of numbers to tables

[Anonymous]

I would expect that the following statement adds a new column with lists of numbers:

Table.AddColumn(#"Table", "Test", each {1, 2, 3})

Instead, the items in the lists are the numbers in text(!) format:

How can I avoid this?

[Vijay_A_Verma · Accepted solution]

Though it shows left aligned but type is number only. If you use following, you will find that TRUE is populated in the list

= Table.AddColumn(#"Table", "Test", each List.Transform({1, 2, 3}, (x)=>x is number))

if you use this, you will find FALSE

= Table.AddColumn(#"Table", "Test", each List.Transform({1, 2, 3}, (x)=>x is text))

Now, the type is set for the column not for list which you can do with below statement

= Table.AddColumn(#"Table", "Test", each {1, 2, 3}, type {Int64.Type})

When you expland this column, you will column type is set to Whole number. Otherwise column type will be set to Any.

= Table.AddColumn(#"Table", "Test", each {1, 2, 3}, type {Int64.Type})

[Anonymous]

---

@Vijay_A_Verma wrote:

Though it shows left aligned but type is number only.

---

This is really strange! Do you have an explanation why it's shown left aligned?

[Anonymous]

Table.AddColumn(#"Table", "Test", each List.Numbers(1,3,1))

--Nate 

[Anonymous]

"{1, 2, 3}" was just an example.
Anyway, your solution gives the same result as described as an issue by me above.