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
MFelix's avatar
MFelix
Super User
6 years ago

HI rosscortb ,

 

If you have a date field in both table you should use it to make an additional filter on your values so that you can have the correct result at the correct time.

 

Can you share some sample data?

  • 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?