Aging by Tickets Open

[renatofrancavr]

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

[v-micsh-msft]

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

[renatofrancavr]

Hi Michael,

My PB is in Portuguese. We use ";"

Thanks for your help.

Regards,

Renato

[BhaveshPatel · Accepted solution]

@renatofrancavr

Please download this solution at below link.

https://drive.google.com/open?id=0B5-C_3XrFPdOMEZZc05OQ1lxYWc

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.

[renatofrancavr]

Hi @BhaveshPatel.

The problem was resolved.

Thanks for your help.

Regards,

Renato