Calculate the aging of the received items

[Krish4Work]

I have 4 inventory transactional tables that defines items received, items sold, items transfered, item adjusted and 2 Item information tables in my report.

I need to calculate the Aging of these items. The aging has buckets of time durations like 0 - 30 days, 30 - 60 days and so on.

and in this buckets are the qty of the items. The mechanism of the Aging report is that any item that is sold should be deducted from the oldest bucket (in my case the last years bucket) then it should start deducting from the previous buckets.

Ive made measures for this purpose. but its taking a lot of system resources.

How can i optimize this report.

You can download my .pbix file from this link We-transfer link 

[Krish4Work]

Hi @lbendlin Thnx for replying..

Well Actually, table named invn_sbs is supposed to be the dimension table.. but in this test lab, the data is incorrect as it has duplicate inventory items causing many to many relationship between tables. I'll check on the data and correct it and upload a new pbix file.

[lbendlin]

Please check your data model. Are you sure that INVN_UDF_V is the only dimension table?