Sum not aggregating over mm-yyyy with conditional expression for > one year

[DawidDaw]

Hello,

I have an issue where my sum is not aggregating correctly over my dimension. The sum is made over the exact date, giving me multiple instances of each month instead of aggregating over month-year  - see picture below.

This is caused by my condition in the dimension:

=if(interval(line_invoice_due_date-today(),'d') >= 360,'Due in more than 360 days',
if(interval(line_invoice_due_date-today(),'d') <= -360,'Late more than 360 days',
date(line_invoice_due_date,'MM-YYYY')))

For the measure, I simply sum(line_amount). Everything is in the same table and the lines are unique.

It works fine without the condition but it goes back too much into the past and future, where we only care about rolling year + and year -.

Any idea how to fix this?

Thanks!

[DawidDaw]

Bump