Calculate Ageing

[Anonymous]

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

[shabirAhmad]

Hi, Can someone tell i have same requirements but reverse of this requirement. I just want to show data filter from number of days as parameters, But the report will not show past date it will show only future date. Let say our item is expiry date is after 30 days as i enter 30 days the report will show those items which will be expired withing 30 days. in the same manner if i enter 60 days the report shows those items will be expired within 60 days etc.

Best Regards,

Shabir Ahmad

[jdbuchanan71]

@Anonymous 

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.

[Anonymous]

@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

[jdbuchanan71]

Hello @Anonymous 

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

[Anonymous · Accepted solution]

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