Forum Discussion

garynorcrossmmc's avatar
garynorcrossmmc
Icon for Advocate IV rankAdvocate IV
5 years ago

Relating Date Table to Min/Max Dates

Hi all, I am working on a Headcount Details report, where the users requested a filter to show all employees as of a certain date - so the filter will be called 'As Of Date.'   I have indirect re...
Need Help
  • garynorcrossmmc's avatar
    garynorcrossmmc
    Icon for Advocate IV rankAdvocate IV
    5 years ago

    Hi amitchandak, thank you for your response!

    I actually used that measure before to count the amount of employees.  But what I'm trying to do is filter the fact table (HR FACT_WORKFORCEEVENT) to show the detail of that count.  So this detail tab would include all rows of those active employees.  How do I build that column to filter the table?