topic Calculate the aging of the received items in DAX Commands and Tips

Calculate the aging of the received items

Krish4Work — Fri, 23 Dec 2022 10:56:53 GMT

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

Re: Calculate the aging of the received items

lbendlin — Sat, 24 Dec 2022 18:12:36 GMT

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

Re: Calculate the aging of the received items

Krish4Work — Tue, 27 Dec 2022 09:04:47 GMT

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.