cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I

## Aging by Tickets Open

Hi,

I have two tables (Base N2 and Calendars) and two columns in my excel base "Ticket Number" and "reported_date" (Open Tickets), I need to calculate the Age of the tickets.

Follow below the formula that i used, but it did not work.

Aging2 = IF(TODAY()-'Base N2'[reported_date]<=5;"1-5 days";IF(TODAY()-'Base N2'[reported_date]<=15;"6-15 days";IF(TODAY()-'Base N2'[reported_date]<=30;"16-30 days";"+30 days")))

Can you help me?

Regards,

Renato

1 ACCEPTED SOLUTION
Community Champion

@renatofrancavr

Follow the process of creating new calculated columns and You would see the expected results for your data.

Let me know if you need further help.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
4 REPLIES 4
Microsoft Employee

Hi renatofrancavr,

You need to switch all ";" to "," to make the formula work in Power BI desktop. The formula should be:

Aging2 = IF(TODAY()-'Base N2'[reported_date]<=5,

"1-5 days",

IF(TODAY()-'Base N2'[reported_date]<=15,

"6-15 days",

IF(TODAY()-'Base N2'[reported_date]<=30,

"16-30 days",

"+30 days")

)

)

See:

Please post back if you need any further assistance regarding DAX calculation.

Regards

Helper I

Hi Michael,

My PB is in Portuguese. We use ";"

Regards,

Renato

Community Champion

@renatofrancavr

Follow the process of creating new calculated columns and You would see the expected results for your data.

Let me know if you need further help.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Helper I

The problem was resolved.

Regards,

Renato

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

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

#### Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors