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
mussaenda
Super User
Super User

Get number between two numbers

Hi,

 

I would like to ask if it's possible to get the number between the two numbers? Please see photo below.

Untitled.png

for example, the first red box

From Entry No : 57

To Entry No : 60

 

What I need is to show the numbers between them with the date same to the row of from entry no to to entry no

Entry No : 57, 58, 59, 60.

Instead of having one row, I will now have 4 rows.

 

Please let me know if this is possible. Thank you.

 

Sample:

From Entry No.       To Entry No.              Date

1                                    5                    31/05/2019

6                                    7                    01/06/2019

 

Expected:

Entry No.                 Date

1                             31/05/2019

2                             31/05/2019

3                             31/05/2019

4                             31/05/2019

5                             31/05/2019

6                             01/06/2019

7                             01/06/2019

 

 

Thank you.

 

Mia

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@mussaenda 

 

Using Power Query, add following custom column>>then expand to new rows

 

={[From Entry No_]..[To Entry No_]}

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

@mussaenda 

 

Using Power Query, add following custom column>>then expand to new rows

 

={[From Entry No_]..[To Entry No_]}

It worked perfectly!

Thank you @Zubair_Muhammad 

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.