I've had this problem for a couple of days and found some "solutions" online. However, none of them worked.
The goal is to calculate Inventory Turnover, but the problem is I can't seem to return the current number of days in the selection.
The solution I found was:
Count(Descendants([Date].[Date Hierachy], [Date].[Date Hierachy].[Date]))
Which returned this:
However, I just want it to return the number of days that are in the selection, so the number of days between (incl) 22/08 and 25/09.
This is a screenshot of my datedim, if it helps:
I can imagine this could be real simple or some setting that I didn't find on the dimensions, but it would be really appreciated if I could find a solution like this...
View Complete Post