Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Devon_Runner
New Member

Create a table with values between from and to columns

HI

 

I would like to create a new table that shows the numbers in each Group ID, between 2 Ref ID columns

 

Current Data table

Group IDRef ID fromRef ID to
Test1500999
Test210001499

 

Requirement

Group IDRef ID
Test1500
Test1501
Test1502
Test1999
Test21000
Test21001
Test21002
Test21499
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, @Devon_Runner 

I used your information to create a table named Table:

vyohuamsft_0-1727057996328.png

 

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]
)

 

Here is my preview:

vyohuamsft_2-1727058066451.png

 

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.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi, @Devon_Runner 

I used your information to create a table named Table:

vyohuamsft_0-1727057996328.png

 

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]
)

 

Here is my preview:

vyohuamsft_2-1727058066451.png

 

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.

HotChilli
Super User
Super User

In Power Query {500..999} is a list that contains all the numbers between these 2 limits.

So,  add a custom column and use the column headings to make your list, then expand the list.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.