Inventory Days on hand date build up

[MrElJerko]

I'm working on metrics for our inventory Days on hand. Let's say I have a table with weekly inventory information, a table with weekly sales information and a calender date table. I need everything is linked together by an Item table and the date table.

To calculate my days on hand I need (period Days * average inventory) / Total Cogs

I'm getting stuck on the number of days. if it's just weekly i can just plug in a 7. but we run 4-4-5 months so there's no such figure for the months. Is there a way i can get the equation to count the days in my period from my calender table and use that so i can get granularity for the month or year?

Here's my weekly formula

=(7*sum(WeeklyInventoryOnHand[WEEKLY_AVERAGE_INVENTORY_VALUE]))/Sum('Sales inf'[COGS])

of course my sum for the inventory will have to be replaced with an average but its the "7" that's really giving me trouble.

Thanks!
-Chris

 

[bschwartz]

Can you post a sample of how your calendar table looks? To be clear, is the goal to count the number of days in the quarter?

 

[scottsen]

Unless something wacky is going on... COUNTROWS(Calendar) should do what you want...?

 

[MrElJerko]

Unless something wacky is going on... COUNTROWS(Calendar) should do what you want...?

Countrows works. Actually it looks like this was totally my mistake, as I was missing some filtering context on the year that exists in my time table, but not in my sales or inventory table. I totally forgot about it.

Thanks for the help.