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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
v-yohua-msft
Community Support
Community Support

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
v-yohua-msft
Community Support
Community Support

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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