Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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_]}
User | Count |
---|---|
143 | |
71 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |