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

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

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.