Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
31 | |
31 | |
22 | |
16 | |
12 |
User | Count |
---|---|
21 | |
20 | |
16 | |
11 | |
10 |