Forum Discussion
Expression.Error: We cannot apply field access to the type Number.
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?
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 TeamIf 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
1 Reply
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 TeamIf 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