This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
Hi,
I would like to ask if it's possible to get the number between the two numbers? Please see photo below.
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
Solved! Go to Solution.
Using Power Query, add following custom column>>then expand to new rows
={[From Entry No_]..[To Entry No_]}
Using Power Query, add following custom column>>then expand to new rows
={[From Entry No_]..[To Entry No_]}
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 27 | |
| 26 | |
| 22 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 45 | |
| 43 | |
| 41 | |
| 21 | |
| 20 |