Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
JVKR
Frequent Visitor

Calculation required for aging report based on stage value

Need to generate a aging report based on the duration between stage to stage(stage value is like unactioned, call  scheduled, meeting scheduled,closed).

idleadidcreated dateold valenew valuefieldunactioned durationcall scheduled durationmeeting scheduled durationclosed duration
1a2a01-Jan-22 unactionedstage    
1b2a08-Feb-2212priority    
1c2a18-Mar-22unactionedcall scheduledstage76   
1d2a25-Apr-22call scheduledmeeting scheduledstage 38  
1e2a02-Jun-22meeting scheduledclosedstage  38152

 

 

Calculations reuired.

unactioned durationcall scheduled durationmeeting scheduled durationclosed 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)
4 REPLIES 4
JVKR
Frequent Visitor

@BGB, i dont see any option to attach the file, can you guide me how can i attach the sample file

@JVKR  Put in Onedrive and share the URL via the link.

JVKR
Frequent Visitor

BGB
Helper II
Helper II

Do you have a sample data file you could attach? @JVKR 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors