cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MaheshGupta Frequent Visitor
Frequent Visitor

Calculate Ageing

Hi,

 

I'm trying to calcualte ageing of a tickets created which is 6 months old. I don't know how to segregate the data based on the "create date" and "last update date".

 

I've created ageing of the tickets day-wise, I need to segregate them month-wise using the age of the ticket.

 

Any help on this would be appreciated!!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Nskv Regular Visitor
Regular Visitor

Re: Calculate Ageing

If it is just a snapshot of the current moment then I would create a calculated column:

daysOld = DATEDIFF(table[Created Date], TODAY(), DAY)

And then you can create another calculated column for the categories:

daysOldCategory = 
IF(table[daysOld] < 15; "Less than 15 days"; 
IF(table[daysOld] <= 30; "15-30 days"; 
IF(table[daysOld] <= 60; "30-60 days"; "60 days and above")))
4 REPLIES 4
Super User
Super User

Re: Calculate Ageing

@MaheshGupta 

Are you trying to add the aging buckets as a calculated column on your ticket table?  Can you share a sample of your data that can be copy and pasted easily?  (paste the sample from excel, not a picture of the data).  If you put the sample data together in a table in your .pbix then export it to .csv you can copy and paste from the data.csv file.

 

 

Highlighted
MaheshGupta Frequent Visitor
Frequent Visitor

Re: Calculate Ageing

@jdbuchanan71 Yes, I'm trying to create calculated columns. I've these following columns which I'm trying to calculate:

  1. Ticket ID
  2. Created Date

I need to find the ageing of the tickets based on the following category:

  1. 15-30 days
  2. 30-60 days
  3. 60 and above days
Nskv Regular Visitor
Regular Visitor

Re: Calculate Ageing

If it is just a snapshot of the current moment then I would create a calculated column:

daysOld = DATEDIFF(table[Created Date], TODAY(), DAY)

And then you can create another calculated column for the categories:

daysOldCategory = 
IF(table[daysOld] < 15; "Less than 15 days"; 
IF(table[daysOld] <= 30; "15-30 days"; 
IF(table[daysOld] <= 60; "30-60 days"; "60 days and above")))
Super User
Super User

Re: Calculate Ageing

Hello @MaheshGupta 

Give this a try.

Aging Bucket =
VAR DaysAge =
    DATEDIFF ( Table[Created Date], TODAY (), DAY )
RETURN
    SWITCH (
        TRUE (),
        DaysAge < 15, "0-14 days",
        DaysAge < 30, "15-29 days",
        DaysAge < 60, "30-59 days",
        "60+ days"
    )

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 299 members 3,644 guests
Please welcome our newest community members: