Forum Discussion
Number of Days between two dates split by month - Employee Data
Hi All Hoping you guys can direct me in the right direction, i've spent hours searching the forums and tried various suggesstions but nothing seems to work as i need it to. This post will be...
barritown
Solution Sage
Solution SageAgree, my arithmetic skills are in decline. 😅
I can propose another measure on top of the earlier one:
Result =
IF ( ISFILTERED ( 'Date'[Month] ),
[Counter],
VAR _tbl = ADDCOLUMNS ( CROSSJOIN ( VALUES ( 'Date'[Month] ), 'Data Table' ), "Temp", [Counter] )
RETURN SUMX ( _tbl, [Temp] ) )
Hi Thanks for sending this. In isolation this works perfectly, however as soon as i add a slicer to the report and filter for one specific month it goes back to the counting the number of days in the calendar rather than sickness days.
- barritown
Hi, yup, the solution was not universal.
You filter months and what else?
So i've got a date hierarchy on the 'Month Ending' date in my date table. I use the month from this hierarchy to filter results