Forum Discussion

dzaba's avatar
dzaba
Frequent Visitor
4 years ago

Employee count per date

Hi Guys,    I have a problem with one of my formula:   #Employee Count = VAR selectedDate = MAX('Date'[Date]) RETURN SUMX('VW_DMMD_DLR_INFO', VAR employeeStartDate = [EMP_START_DT] VAR ...
Need Help
dzaba's avatar
dzaba
Frequent Visitor
4 years ago

Hi, thanks for the link. I belive it will work for me, but I am looking for solution for this specific measure.

  • v-angzheng-msft's avatar
    v-angzheng-msft
    Community Support
    4 years ago

    Hi, dzaba 

     

    Do you mean that the current count is 20, but the correct count is 19?
    What does your date table look like? Is the count based on today's date? How do you show your measure, with a table or with a card or?
    I tried to show your measure on card and got the correct result 19. I think your measure is completely correct, maybe there are errors in the details.

    Could you please consdier sharing more details about it or a simple sample file without any sesentive information for further discussion?

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.