Last year count with userelationship dax

Question

Hi experts,Need to calculate last year new hire count&nbsp;Please help.&nbsp;New Hire = CALCULATE(COUNT('Exit,Roster,Leave,WFH'[ID]),USERELATIONSHIP('Calendar'[Date], 'Roster'[Hire Date]))New Hire PY = CALCULATE( DISTINCTCOUNT('Roster'[ID]),SAMEPERIODLASTYEAR('Calendar'[Date]),USERELATIONSHIP('Calendar'[Date], 'Roster'[Hire Date]))getting blank output for second formula

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;&nbsp;This modified formula will count the number of new hires for the previous year based on the 'Hire Date' relationship with the 'Calendar' table.CALCULATE(COUNT('Exit,Roster,Leave,WFH'[Axtria ID]),USERELATIONSHIP('Calendar'[Date], 'Roster'[Hire Date]),'Calendar'[Year] = YEAR(TODAY()) - 1)

anonymous · Answer

Hi&nbsp;Anonymous, I tried above formula, shwoing blank value&nbsp;

sergej_og · Answer

Date intelligence....try to use DATEADD or SAMEPRIODELASTYEAR to get your result.
CALCULATE(
     COUNT(ccc),
     DATEADD(xxx),
     USERALTIONSHIP(fff)
)
Regards.

anonymous · Answer

Hi&nbsp;sergej_og&nbsp;,New Hire PY =CALCULATE(&nbsp;DISTINCTCOUNT('Roster'[ID]),SAMEPERIODLASTYEAR('Calendar'[Date]),USERELATIONSHIP('Calendar'[Date], 'Roster'[Hire Date]))tried above and getting blank output&nbsp;

anonymous · Answer

Hi,&nbsp;Anonymous&nbsp;
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?
&nbsp;
&nbsp;
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

Forum Discussion

Last year count with userelationship dax

Related content

RLS and USERELATIONSHIP problem

Counting nulls

USERELATIONSHIP, FILTER, CALCULATE, COUNT

USERELATIONSHIP problems with n:m-relationship

Userelationship measure and count rows