Create a table with values between from and to columns

Question

HI&nbsp;I would like to create a new table that shows the numbers in each Group ID, between 2 Ref ID columns&nbsp;Current Data tableGroup IDRef ID fromRef ID toTest1500999Test210001499&nbsp;RequirementGroup IDRef IDTest1500Test1501Test1502Test1999Test21000Test21001Test21002Test21499

anonymous · Accepted Answer

Hi,&nbsp;Devon_Runner&nbsp;
I used your information to create a table named Table:

&nbsp;
Then try the following DAX expression to create a new table:
NewTable = 
SELECTCOLUMNS(
    ADDCOLUMNS(
        GENERATE(
            'Table',
            GENERATESERIES('Table'[Ref ID from], 'Table'[Ref ID to], 1)
        ),
        "Ref ID", [Value]
    ),
    "Group ID", 'Table'[Group ID],
    "Ref ID", [Value]
)

&nbsp;
Here is my preview:

&nbsp;
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Create a table with values between from and to columns

2 Replies

Related content

Create columns group

Creating a date column

Creating a custom column

unpivoting columns and creating datetime column

Appending columns and creating new column of old column headers

Group ID	Ref ID
Test1	500
Test1	501
Test1	502
Test1	999
Test2	1000
Test2	1001
Test2	1002
Test2	1499