Expression.Error: We cannot apply field access to the type Number.

[ADI1212]

hi all!

im trying to generate a list of years in a custom column

i have a first year and last year columns

the list should list all years from the first year until the last year

i tried the following:

Table.AddColumn(#"Filtered Rows", "Custom", each

List.Generate (() => [#"First year"], each _ <[#"Last year "], each _ +1 ))

but i always get this error :

Expression.Error: We cannot apply field access to the type Number.
Details:
Value=2022
Key=Last year 

anybody knows how to solve this?

[Anonymous · Accepted solution]

Hi @ADI1212 ,

In your case, it’s being evaluated in the context of the individual numbers generated by , not in the context of the table rows. you need to reference the columns outside of the function. Here’s how you can modify your code:
Please try like:

let
startYear = [#"First year"],
endYear = [#"Last year"]
in
List.Generate(() => startYear, each _ <= endYear, each _ + 1)

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum