Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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})
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})
@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?
Table.AddColumn(#"Table", "Test", each List.Numbers(1,3,1))
--Nate
"{1, 2, 3}" was just an example.
Anyway, your solution gives the same result as described as an issue by me above.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.