Forum Discussion
Create Sequential Numbering Between Values in a column
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.
Community Championr_cruiser You want to use GENERATESERIES. GENERATESERIES function - DAX | Microsoft Learn
I understand the concept of GENERATESERIES, but do not know the implementation for my source table to end with the expected table.
GENERATESERIES. It would seem to me as if I need a loop to generate a series of values between two known values for each group to construct a single table.
Is there a way to generate a series for each group? It's not straight forward to me. Not yet.- Greg_Deckler
r_cruiser Something like this:
Table 2 = GENERATE( DISTINCT('Table'[y]), GENERATESERIES(MAX('Table'[Group_MinX]), MAX('Table'[Group_MaxX]), .25) )It's the basic technique from Blowout!
Blowout! - Microsoft Power BI Community
