Tableau Calculated Field to Power BI Calculated Column

[Curious2115]

Hello,

I have this calculated field in Tableau that I am trying to convert into a calculated column in Power BI, but it is giving me a type error. I am going to use this calculated column to create other calculated column. What am I doing wrong? Any help would be greatly appreciated. Please see the codes below.

Tableau Code:

     IF DATEPART('month',[DATE]) = DATEPART('month',TODAY())
     and DATEPART('day',[DATE]) < DATEPART('day',TODAY())

     then int((DateDiff('month',[DATE],(DATEADD('month', 0, TODAY()))))/12)
     else int((DateDiff('month', [DATE],(DATEADD('month', -1, TODAY()))))/12) END

Power BI code:
       yr = IF('Document'[DATE].[Month] = MONTH(NOW())
       && 'Document'[DATE].[Day] < TODAY(),

       INT('Document'[DATE].[Month] - MONTH(NOW()))/12,
       INT('Document'.[Month] - (MONTH(NOw()) -1))/12)

[amitchandak · Accepted solution]

@Curious2115 , Try like

yr = IF( month('Document'[DATE])= MONTH(today())
&& day('Document'[DATE]) < day(TODAY()),

datediff('Document'[DATE] , MONTH(today()), month)/12,
datediff('Document'[DATE] , MONTH(eomonth(today(),-1)), month)/12)

or

yr = IF( month('Document'[DATE])= MONTH(today())
&& day('Document'[DATE]) < day(TODAY()),

datediff('Document'[DATE] , MONTH(today()), month)/12,
datediff('Document'[DATE] , MONTH(date(year(today()),month(today())-1,day(today()))), month)/12)

[Curious2115]

Thank you!