Return a dynamic list of values

[Zyg_D]

This is the data:

col1	col2
2012	2013
2012	2014
2017	2020

I cannot think of a way to get the 3rd column which would represent the full duration in text (from the value in the 1st column to the value in the 2nd column). Any guidance is well appreciated. 

col1	col2	col3
2012	2013	2012,2013
2012	2014	2012,2013,2014
2017	2020	2017,2018,2019,2020

[amitchandak · Accepted solution]

@Zyg_D , Try a new column like

concatenatex( GENERATESERIES([year1] ,[year2],1), [Value])

In case it gives an error for value

Create a new table using this GENERATESERIES(1 ,10,1) and check column name and use that

[Zyg_D]

---

@amitchandak wrote:

@Zyg_D, Try a new column like

concatenatex( GENERATESERIES([year1] ,[year2],1), [Value])

---

This worked well:

newcol = CONCATENATEX( GENERATESERIES( table[col1], table[col2], 1), [Value], ",")

Thanks