Forum Discussion

Curious2115's avatar
Curious2115
Frequent Visitor
5 years ago
Solved

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 crea...
  • amitchandak's avatar
    amitchandak
    5 years ago

    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)

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Curious2115
    Frequent Visitor
    5 years ago

    Thank you!