Forum Discussion

renatofrancavr's avatar
renatofrancavr
Helper I
9 years ago
Solved

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 formu...
Need Help
v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
9 years ago

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's avatar
    renatofrancavr
    Helper I
    9 years ago

    Hi Michael,

     

    My PB is in Portuguese. We use ";"

     

    Thanks for your help.

     

    Regards,

    Renato