Forum Discussion

Hari01's avatar
Hari01
Frequent Visitor
3 years ago
Solved

Generate delimited sequence upto N in each row

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 

Levelsequence
41,2,3,4
71,2,3,4,5,6,7
51,2,3,4,5
11
31,2,3

 

Any idea how to do in Power BI ?

 

Thanks in advance 

 

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    3 years ago

    Hari01 

     

    With Power Query, you can add a custom column like

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

2 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hari01 

     

    With Power Query, you can add a custom column like

    Text.Combine(
List.Transform({1..[Level]},each Text.From(_)),",")
  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    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