how to club 360 days and 360+days aging balances into 360 day bucket

[gauri]

I was trying to figure out my aging sample data quite a long back,

Can anyone suggest me some ideas to overcome my challenge :

I select a date in my slicer as Jan 2020 which returns me my aging bucket for last 12 months i.e till Jan 2019 using the below dax : output =

var current_date = MAX(Date[Date])

var previous_date = DATE(YEAR(current_date),MONTH(current_date)-12,1)

var result = CALCULATE(SUM(aging[amt]), FILTER(aging, aging[e_date] >= previous_date && aging[e_date] <=current_date ) ) return result

But the problem is i have some values which are present before Jan 2019 so i want to club all those values after Jan 2019 into my last bucket i.e last bucket would consist balance for 360 and 360+ days .

Thank you

[v-deddai1-msft]

Hi @gauri ,

Your description is not very clear to me. Would you please inform us more detailed information( your sample data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai