Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Calculated column based on filters.

I want to create the following measure:   Hires = count of those employees whose transaon date = date[first date]). When I manually enter the first date, the value comes up.   The Manual par...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

okay i'll try and let u know in a while! Thanks Anonymous@

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey I have the following situation.

 

I have given a date range from 2010 to 2020.

 

I want to create the following measure: Count the number of employees if date hired of employees = last date in date table (I created this date table), else 0.

 

I created the following measure till now:  Measure = CALCULATE(COUNT(Employees[ID]), Filter(Employees, Employees[HireDate]= 'Date Table'[Last Date])

 

So bascally I want to calculate the count when hire date matches last date, else I want it to return 0. However, it returns weird values even for the year 2019 in the filter. Is there a way in which this can be calculated?

 

Thank You!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

    What is the last date in date table? Is it a measure? Could you please share sample data of your table and post expected result  based on the sample data?

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hey, I had posted my sample under a different discussion called "Calculated Column based on Filters" yesterday. There is a detailed description there. Anonymous

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous，

    Do you want to get same expected result in the two different discussion? If so, I will merge the  two threads.

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous Yes, They are related. So I guess you can merge it. Thank You!