Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
61 | |
53 | |
27 | |
16 | |
10 |