Forum Discussion
rosscortb
Post Patron
Post PatronMeasure 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...
MFelix
Super User
Super UserHI 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?
rosscortbHi, 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