Last year count with userelationship dax

[SonaSinghA]

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]))

New Hire PY =

CALCULATE( DISTINCTCOUNT('Roster'[ID]),

SAMEPERIODLASTYEAR('Calendar'[Date]),

USERELATIONSHIP('Calendar'[Date], 'Roster'[Hire Date]))

getting blank output for second formula

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  Show the problem there clearly.

[Venkateshchiluk]

Hi @SonaSinghA  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
)

[SonaSinghA]

Hi @Venkateshchiluk, I tried above formula, shwoing blank value 

[sergej_og]

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

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

Regards.

[SonaSinghA]

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 

[v-jianpeng-msft]

Hi, @SonaSinghA 

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