Forum Discussion
Anonymous
5 years agoNot applicable
Date connection not correct
I have been working on this for some time now and its not working just yet. I used to have it working fine, but something broke and I cant figure out what it is.
I have a measure that tells me the current active count of employees by month. It looks like this:
Active Count = CALCULATE(COUNTROWS('Metrics'),FILTER(VALUES( 'Metrics'[Hire Date]),'Metrics'[Hire Date]<=MAX('Date Table'[Date])),FILTER(VALUES('Metrics'[Termination Date]),OR('Metrics'[Termination Date]>=MIN('Date Table'[Date]),ISBLANK(' Metrics'[Termination Date]))))
I then have this equation using an inactive relationship with both the hire date and termination to my date table. I then use then use the userrelationship function to activate both of those dates. The above equation merits the use of doing it this way.
for some reason though, the dates are not matching up with active count. Any ideas on how to get them to match up?
Hi,
Share some data, describe the question and show the expected result.
1 Reply
- Ashish_Mathur
Super User
Hi,
Share some data, describe the question and show the expected result.