Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Last year count with userelationship dax

Hi experts, Need to calculate last year new hire count  Please help.   New Hire = CALCULATE( COUNT('Exit,Roster,Leave,WFH'[ID]), USERELATIONSHIP('Calendar'[Date], 'Roster'[Hire Date])) ...
Need Help
sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
2 years ago

Date intelligence....try to use DATEADD or SAMEPRIODELASTYEAR to get your result.

CALCULATE(
     COUNT(ccc),
     DATEADD(xxx),
     USERALTIONSHIP(fff)
)


Regards.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi sergej_og ,

New Hire PY =
CALCULATE( DISTINCTCOUNT('Roster'[ID]),
SAMEPERIODLASTYEAR('Calendar'[Date]),
USERELATIONSHIP('Calendar'[Date], 'Roster'[Hire Date]))

tried above and getting blank output 
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    Have you solved the current problem? I looked at your DAX expression and it seems to be correct. Are you able to provide some sample data or PBIX files that don't contain privacy?

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li