Wrong bucket result age receibales

[MilicaPavlović]

Hi.I have problem with result in aging bucket, but total result is correct. I have calendar table connected to table where is data:document, date of document, due date, amount (active relationship  calendar date to date of document, and ineactive date to due date).  I followed instructiom from this linkhttps://community.powerbi.com/t5/Desktop/Calculate-Transaction-age-for-Vendor-Aging-Report/td-p/931259/highlight/true. My result is 954 212 as current, but it should be 2.053.216,8. Formula for age bucket and other are down. Thank you.

[v-yuta-msft]

@MilicaPavlović ,

Could you share some sample data and clarify more details about your expected outcome?

Best regards

Jimmy Tao

[v-yuta-msft]

@MilicaPavlović ,

Could you please share some sample data and clarify more details about your expected result?

Regards,

Jimmy Tao

[MilicaPavlović]

Hi, thanks for reply. Data is located on this link link

I hope you can download it. In first sheet is amount of total due it is 7.015.156,31 current is 2.053.216,8 so this amount must be current in sheet 2 (Age bucket) and difference between 7.015.156,31 and 2.053.216,8 is overdue amount. Overdue amount should be in age bucket from 0 to 30 to 90+. I dont know what is wrong. I am new user. I tried many ways to do this but unfortunately without success.

Data is located in table Kartice partnera.

[MilicaPavlović]

@v-yuta-msft