Creating a number range between two values

[opticshrew]

Hi all,

I'm trying to create a column which contains all values between to numbers. 

Example.

Start Number      End Number          Range
     1                4              1:2:3:4
     2                4               2:3:4
     3                4                3:4
     4                4                 4   

Any ideas on how I can achieve this?

I would've used some form of iteration however I don't believe Power Bi has this functionality yet.

Thanks,

J

[MarcelBeug · Accepted solution]

Piece of cake for Power Query:

let
    Source = Table1,
    #"Added Custom" = Table.AddColumn(Source, "Range", each Text.Combine(List.Transform({[Start Number]..[End Number]},Text.From),":"))
in
    #"Added Custom"

[Anonymous]

While using this Mquery, I am getting error"

I am using an excel Data source:

I want to create numbers between Start Number and End Number but i am getting error" Expression.Error: The field 'Start Number' of the record wasn't found."
My Mcode is: 

[opticshrew]

Hi @MarcelBeug

Excellent, does the job niceley.

Thanks,

J

[Anonymous]

While using this Mquery, I am getting error"

I am using an excel Data source:

I want to create numbers between Start Number and End Number but i am getting error" Expression.Error: The field 'Start Number' of the record wasn't found."
My Mcode is: 

Please help me on this.