Forum Discussion

r_cruiser's avatar
r_cruiser
Regular Visitor
3 years ago
Solved

Create Sequential Numbering Between Values in a column

Hi, I am trying to create sequential values between two values per group. Column y = group Column x = Fill between values Here's the source table created in Power Query:   Here's the ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi r_cruiser ,

    I have created a simple sample, please refer to it to see if it helps you.

    Create a table.

    Table =
SELECTCOLUMNS (
    FILTER (
        GENERATE (
            Src_Table,
            GENERATESERIES (
                MIN ( Src_Table[Group_MinX] ),
                MAX ( Src_Table[Group_MaxX] ),
                0.25
            )
        ),
        [Value] >= Src_Table[Group_MinX]
            && [Value] <= Src_Table[Group_MaxX]
    ),
    "Label", Src_Table[y],
    "Value", [Value]
)

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi r_cruiser ,

I have created a simple sample, please refer to it to see if it helps you.

Create a table.

Table =
SELECTCOLUMNS (
    FILTER (
        GENERATE (
            Src_Table,
            GENERATESERIES (
                MIN ( Src_Table[Group_MinX] ),
                MAX ( Src_Table[Group_MaxX] ),
                0.25
            )
        ),
        [Value] >= Src_Table[Group_MinX]
            && [Value] <= Src_Table[Group_MaxX]
    ),
    "Label", Src_Table[y],
    "Value", [Value]
)

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • r_cruiser's avatar
    r_cruiser
    Regular Visitor
    3 years ago

    Anonymous 

    Thank you.  That solution helped out almost immediately.  It took me some review time to understand the syntax but I get it now.

    Thank You again!