Hi. Example:
let
fxNumbers = (x, y) as list => {x..y},
Source = #table(type table [Alpha=text], {
{"a"},{"b"}}),
NewTable = Table.FromColumns(
{
List.Combine(Table.ToColumns(Source)),
fxNumbers(1, 3)
},
{"Alpha", "Numbers"}
) // => [Numbers] type is any (not what I expect)
in
NewTable
So far the only way I've found (after searching and trying...) to return an ascribed list out of fxNumbers:
fxNumbers = (x, y) as list =>
Value.ReplaceType({x..y}, type {number})
Q: Is it the way to go or is there a better/recommended alternative?
Thanks