Average Inventory

[mboucher_rcr]

Hi,

I am trying to calculate GMROI per item and am having trouble getting the average inventory cost.

My data is something like this:

Date	Store	Item	SOHValue
30 May 2022	A	1	10
30 May 2022	B	1	20
6 June 2022	A	1	10
6 June 2022	B	1	20
13 June 2022	A	1	10
13 June 2022	B	1	20

If I try 

AvgSOHValue = AVERAGE(ItemSales[SOHValue])

I get 15 because it divides total SOH (90) by the number of records (6).

Instead I want the 90 divided by the number of dates (3), so I'm getting an average SOH overall instead of per store.

Can anyone please help?

Thanks,
Michael

[ddpl · Accepted solution]

@mboucher_rcr 

Create below measure and put it in card

Avg = SUM(ItemSales[SOHValue]) / DISTINCTCOUNT(ItemSales[Date])

Hope it will work for you.