Forum Discussion
r_cruiser
4 years agoRegular Visitor
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 ...
- Anonymous4 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
4 years agoRegular Visitor
Each group have different start and end values. GENERATESERIES accepts an absolute single value. Hmmm.