7 Replies Latest reply: Dec 4, 2013 11:55 AM by Adam Fearnhead RSS

    Count resources available before a date

      Hi,

       

      I am currently tracking supply and demand within an app.

       

      I am looking to create a chart which shows the demand for skills as well as the currently supply of employees we have before a demand start date.

       

      I have the chart which shows the current current employees available now vs the amount of employees wanted with these two expressions:

       

      Available skills
      Count({$<[Billable_Status] = {'Non-Billable}>}[Billable_Status]

       

      Resources wanted

      Sum({1}[Resources_Wanted])

       

      The dimension is [Employee_Primary_Skill]

       

       

      What I'd like to do now is count the employees which become available before a demand start date, I have two dates for this [Employee_Allocation_End]  and [Demand_Billable_Start]. The dimension on the chart would no longer be shown by skill but [Demand ID] but the employee would still have to have the same primary skill the demand needs.

       

      Thanks in advance, sorry if I've made this seem confusing. I'm a bit baffled myself!