Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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 ID | Ref ID from | Ref ID to |
Test1 | 500 | 999 |
Test2 | 1000 | 1499 |
Requirement
Group ID | Ref ID |
Test1 | 500 |
Test1 | 501 |
Test1 | 502 |
Test1 | 999 |
Test2 | 1000 |
Test2 | 1001 |
Test2 | 1002 |
Test2 | 1499 |
Solved! Go to Solution.
Hi, @Devon_Runner
I used your information to create a table named Table:
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:
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.
Hi, @Devon_Runner
I used your information to create a table named Table:
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:
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
80 | |
79 | |
59 | |
36 | |
35 |
User | Count |
---|---|
99 | |
57 | |
56 | |
46 | |
40 |