Forum Discussion

rosscortb's avatar
rosscortb
Post Patron
6 years ago

Measure that returns the current value

Hello,   Hoping you can help. I have two tables, headcount and Submitted Approved. I have used this measure to bring in the sector that the employees works in from the headcount table to the Subm...
Need Help
rosscortb's avatar
rosscortb
Post Patron
6 years ago

Hi, I do have have two dates fields in the submitted and approved which is basically start and end date for annual leave so don't think its relevant

 

MFelix's avatar
MFelix
Super User
6 years ago

Hi rosscortb ,

 

If you don't have any start and end date how do you know the Sector of a specificic employee at a certain time?

 

Can you share a sample data and setup of the relationships in you model?