Aging bucket trying to add few more days

[sraj]

Hi,

I have this aging bucket measure, works fine as it is but when trying to add 120 days and above I am getting this error message.  Is it possible for me to add this 120 days and above option?  Please advise.

Aging Bucket =

VAR DaysAge =

    DATEDIFF ( uv_pbi_ar_pro_status_dtl[wf_task_open_dt], TODAY(), DAY )

RETURN

    SWITCH (

        TRUE (),

        DaysAge < 15, "Less than 15 days",

        DaysAge <= 30, "15-30 days",

        DaysAge <= 60, "30-60 days", "60 days and above"

                 )

[sraj · Accepted solution]

I ended up using this and it works as needed for me.  

Aging Bucket 2 =

VAR DaysOld =

    DATEDIFF ( uv_pbi_ar_pro_status_dtl[wf_task_open_dt], TODAY(), DAY )

RETURN

    SWITCH (

        TRUE (),

        --or(ISBLANK(DaysOld),DaysOld <= 0), "Overdue",

        DaysOld <= 15, "0-15 Days",

        DaysOld > 15 && DaysOld <= 30 , "15-30 Days",

        DaysOld > 30 && DaysOld <= 60 , "30-60 Days",

        DaysOld > 60 && DaysOld <= 120 , "60-120 Days",

        DaysOld > 120, "120 Days Above"

        )

[YukiK]

Would you provide sample data? Formula looks fine to me