Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Need to generate a aging report based on the duration between stage to stage(stage value is like unactioned, call scheduled, meeting scheduled,closed).
| id | leadid | created date | old vale | new value | field | unactioned duration | call scheduled duration | meeting scheduled duration | closed duration |
| 1a | 2a | 01-Jan-22 | unactioned | stage | |||||
| 1b | 2a | 08-Feb-22 | 1 | 2 | priority | ||||
| 1c | 2a | 18-Mar-22 | unactioned | call scheduled | stage | 76 | |||
| 1d | 2a | 25-Apr-22 | call scheduled | meeting scheduled | stage | 38 | |||
| 1e | 2a | 02-Jun-22 | meeting scheduled | closed | stage | 38 | 152 |
Calculations reuired.
| unactioned duration | call scheduled duration | meeting scheduled duration | closed duration |
| created date(minimum created date)- created date value(if field=stage & New Value=Call scheduled) | created date(if field=stage & old value=call scheduled) - created date(field=stage & new value=call scheduled) | created date(if field=stage & old value=meeting scheduled) - created date(field=stage & new value=meeting scheduled) | created date(if field=stage &new value=closed)- created date(minimum created date) |
@BGB, i dont see any option to attach the file, can you guide me how can i attach the sample file
Please find the sample file in above link.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 4 | |
| 4 | |
| 4 |