How to show all the year within a range in the new column

[Michael_Tsai]

If i have 2 columns, the start of a range and the end of the range, how do i show all the year with in that range?

here [Years] is the example that i want to show:

Start_Year	End_Year	Years
2012	2017	2012,2013,2014,2015,2016,2017
2023	2024	2023,2024
2003	2006	2003,2004,2005,2006

Here are my current solution, using List.generate(). but it didn't work out after i use Text.Combine().

= Table.AddColumn(#"Table1", "Years", each 
    let EY = [End_Year]
    in
        List.Generate(() => [x=[Start_Year]],each [x] <= EY, each [ x = [x] +1], each [x]))

[slorin · Accepted solution]

Text.Combine(List.Transform({[Start_Year]..[End_Year]},Text.From),",")

Stéphane 

[slorin]

Hi

= Table.AddColumn(#"Table1", "Years", each {[Start_Year]..[End_Year]})

Stéphane 

[Michael_Tsai]

how Do i convert the list with number to a string