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 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!
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.