Forum Discussion
Tableau Calculated Field to Power BI Calculated Column
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)
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)
2 Replies
- amitchandak
Super User
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)Thank you!
