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                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

 

 

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"

4 Replies

  • 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: 

        Please help me on this.

         

    • 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: