Inccorect Power BI calculation vs Manual calculation

Hi,

I got issue with the Annualized % calculation where Power BI calculate wrongly for NZ but overall and HK is correct.

For NZ Jan, calculation should be 6/53*366/31 = 1.3365  (133.65%) but Power BI value is 134.9%

Can i know what is the issue ?

Refer the sceershot is manual excel sheet. For overall, NZ and HK

Please refer these dax formula :

Attrition YTD = CALCULATE(sum(Attrition[Count]),DATESYTD('DAX DateTable'[Date]))

Average HC = ([Fiscal Year HC]+[HC])/2 

Fiscal Year HC = sum('Fiscal Year HC'[Count of Employee Type])

HC = count(ActiveHC[Active])

 YTD Count = TOTALYTD(sum('DAX DateTable'[Count]),'DAX DateTable'[Date])

Annualized % = [Attrition YTD]/[Average HC]*366/[YTD Count]

 

Power BI