The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
---|---|
69 | |
68 | |
66 | |
55 | |
28 |
User | Count |
---|---|
112 | |
82 | |
66 | |
48 | |
43 |