Forum Discussion

sshekar7's avatar
sshekar7
Frequent Visitor
10 years ago
Solved

data formating results in 1905

I have two fields employees and Year. I am using this formula to calculate growth rate.   Growth % = divide (sum(Data[EMPLOYEES]) - calculate(sum(Data[EMPLOYEES]),SAMEPERIODLASTYEAR(Data[YEAR])), c...
  • Habib's avatar
    Habib
    10 years ago

    You can use the below method to convert your year to date.

     

    1. Convert the data type of your Year column to Tex
    2. Add custom Column to and use below formula to append date and montht to Year filed

    1. convert the new column type to date

     

    Hopefully this will help.

Habib's avatar
Habib
Icon for Continued Contributor rankContinued Contributor
10 years ago

You can use the below method to convert your year to date.

 

  1. Convert the data type of your Year column to Tex
  2. Add custom Column to and use below formula to append date and montht to Year filed

  1. convert the new column type to date

 

Hopefully this will help.

sshekar7's avatar
sshekar7
Frequent Visitor
10 years ago

Thanks Habib.. it worked..