Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Calulate start date from Year and Month

Hi All, 

 

I am trying create calculated column for  "Start_Date" but its giving an error as Year and month are of different datatype

 

 I also tried below formula but still the same; 

 

Date = 1*("1/"&'date'[Month]&"/"&'date'[Year])

 

 

Need Help
  • johnyip's avatar
    johnyip
    2 years ago

    Anonymous I guess, do you have BLANKS in your [year] or [month]? If so, you need to fix that.

4 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    2 years ago

    hi Anonymous ,

    try like:

    Column = DATEVALUE([Year] &" "& [Month] &" 1")

     

    it worked like:

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi , 

       

      Thanks for the response but I still get same error: 

       

       

       

      • johnyip's avatar
        johnyip
        Icon for Solution Sage rankSolution Sage
        2 years ago

        Anonymous I guess, do you have BLANKS in your [year] or [month]? If so, you need to fix that.