Trying to work out the number of days within a given period
Below function looks correct if the filter is on a year, either get 365, or 364.
However when i filter into Quarters the number does not look right.
Any suggestions please
Can you should the exact context you would like this results in, like how are you representing this calculation.
It’s very important here.
just a KPI Card.
Im not putting into a context as such.
Calculation is being represented as a whole number.
There is always some context. For example the date slicer you are using is creating context for your calculation.
If you are literally just attempting to work out how many days are showing via a particular selection then all you should need to use is this;
Days In Context = COUNTROWS( Datestable )