cancel
Showing results for
Did you mean:
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
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

## Re: Calculate Ageing

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
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
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

## 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"
)
```

Announcements

#### Community Highlights

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

#### Power Platform Summit North America

Register by September 5 to save \$200

#### 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.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 299 members 3,644 guests
Recent signins: