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: Date Store Item SOHValue 30 May 2022 A 1 10 ...
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.
ddpl's avatar
ddpl
Icon for Solution Sage rankSolution 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.