Forum Discussion

mboucher_rcr's avatar
mboucher_rcr
Frequent Visitor
4 years ago
Solved

Average Inventory

Hi,

 

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

 

My data is something like this:

DateStoreItemSOHValue
30 May 2022A110
30 May 2022B120
6 June 2022A110
6 June 2022B120
13 June 2022A110
13 June 2022B120

 

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

Need Help
  • ddpl's avatar
    ddpl
    4 years ago

    mboucher_rcr 

     

    Create below measure and put it in card

     

    Avg = SUM(ItemSales[SOHValue]) / DISTINCTCOUNT(ItemSales[Date])
     
    Hope it will work for you.

1 Reply

  • ddpl's avatar
    ddpl
    Solution Sage
    4 years ago

    mboucher_rcr 

     

    Create below measure and put it in card

     

    Avg = SUM(ItemSales[SOHValue]) / DISTINCTCOUNT(ItemSales[Date])
     
    Hope it will work for you.