Forum Discussion

r_cruiser's avatar
r_cruiser
Regular Visitor
4 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
    4 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
4 years ago

There's a way to do it in Power Query, but creating it in DAX perplexes me.

This the solution in Power Query.  This is not really solved as the OP was asking it to be done in DAX.
Much like I am asking.
Solved: GENERATESERIES OVER A GROUP in POWER BI using DAX? - Microsoft Power BI Community

I perfer it to be done in DAX to decrease load times.  In Power Query load times could be as much as few hundred thousand lines. At time maybe up to 1M lines.