Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Trend Filter Help

Hi All!   I am struggling to create a visual that helps calculate how many ID's and the cost I had over the last year, considering the open and closed date. Through the HR Analytics - Active Employ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try with Min on start date

    Current Employees = CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=Min('Date'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Date'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Date'[Date],None))

     

    if need do same for max. Also check for <= or >=

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try with Min on start date

Current Employees = CALCULATE(COUNTx(FILTER(Employee,Employee[Start Date]<=Min('Date'[Date]) && (ISBLANK(Employee[End Date]) || Employee[End Date]>max('Date'[Date]))),(Employee[Employee Id ])),CROSSFILTER(Employee[Start Date],'Date'[Date],None))

 

if need do same for max. Also check for <= or >=

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Exactly what I was looking for! Thanks so much, amitchandak !

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi @amitchandak,

      Thanks again for all your help! When applying this to real life, for some reason the visual is inaccurate, not considering tickets created this month (or in this case, employees onboarded this month). Can you help me see where it went wrong?