Forum Discussion

opticshrew's avatar
opticshrew
Resolver II
9 years ago
Solved

Creating a number range between two values

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 ...
Need Help
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    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"
MarcelBeug's avatar
MarcelBeug
Community Champion
9 years ago

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's avatar
Anonymous
Not applicable
2 years ago

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: