Generate delimited sequence upto N in each row

[Hari01]

Hi

I have a column which contains integer

Level

4

7

5

1

3

I have to generate sequence starting from 1 and upto the number in Level column in each row, sequence is seperated by comma.

expected output is 

Level	sequence
4	1,2,3,4
7	1,2,3,4,5,6,7
5	1,2,3,4,5
1	1
3	1,2,3

Any idea how to do in Power BI ?

Thanks in advance 

[Zubair_Muhammad · Accepted solution]

@Hari01 

With Power Query, you can add a custom column like

Text.Combine(
List.Transform({1..[Level]},each Text.From(_)),",")

[Greg_Deckler]

@Hari01 Well, in DAX you could use a calculated column like:

sequence = CONCATENATEX(GENERATESERIES(1,[Level]),[Value],",")

I believe the equivalent in Power Query is List.Generate