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
Continued 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..

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Thanks for the Solution, but I have to use this to get the right solution:

    Date = "1/1/" & INT([Year])