how to club 360 + days aging balance into 360 day bucket

[gauri]

How can this be solved:

I have a measure which is calculating a lookback of 12 months from the date selected in the slicer, following is the measure :

Aging Amount =

var current_date = MAX('Date'[Date])

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

var result =

CALCULATE(SUM('pcc_view_ar_aging (2)'[amount]),

FILTER('pcc_view_ar_aging (2)','pcc_view_ar_aging (2)'[effective_date] >= previous_date && 'pcc_view_ar_aging (2)'[effective_date] <=current_date

)

)

return

result

my date table and pcc_view_ar_aging are two disconnected tables.

for the above image i have selected 1/1/2020 in the date slicer which is giving a lookback of 12 months i.e 360 days, but i have my aging balances past 12 months such as dec 2018, nov 2018 and so on till jan 2015, how can i modify the dax in way where all the balances from dec 2018 get clubed into jan 2019 column value.

Thanks

[gauri]

Can anyone help me solve the above issue

[v-easonf-msft]

Hi , @gauri 

Sample data and expected output would help tremendously.

Could you please share your PBIX/some sample data and expected result to me if you don't have any Confidential Information?

Best Regards,
Community Support Team _ Eason