Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have two whole number columns, "Min G/L Account No." and "Max G/L Account No.". I'm trying to create a new, calculated column which contains a list of each whole number between those two (in increments of 1). To do this, I'm using the following query in the Custom Column dialog:
List.Generate(
() => ([#"Min G/L Account No."]),
each _ <= ([#"Max G/L Account No."]),
each _ + 1
)
It accepts the formula, but each field in the newly created list column contains the following error:
Expression.Error: We cannot apply field access to the type Number.
Details:
Value=10020 (NOTE: this value changes per row)
Key=Max G/L Account No.
I've confirmed I can create a list of numbers by just changing the values in the formula to hard coded numbers, but cannot figure out what I'm doing wrong with the formula that is resulting in the error.
Any help would be much appreciated! Thank you in advance!
Solved! Go to Solution.
Hi @Anonymous ,
Try this in a new custom column:
{ [#"Min G/L Account No."]..[#"Max G/L Account No."] }
Note the curly braces.
Pete
Proud to be a Datanaut!
Hi @Anonymous ,
Try this in a new custom column:
{ [#"Min G/L Account No."]..[#"Max G/L Account No."] }
Note the curly braces.
Pete
Proud to be a Datanaut!
That worked perfectly - thanks, Pete!