Calulate start date from Year and Month

[mohiniverma2704]

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])

[FreemanZ]

hi @mohiniverma2704 ,

try like:

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

it worked like:

[mohiniverma2704]

Hi , 

Thanks for the response but I still get same error: 

[johnyip · Accepted solution]

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

[mohiniverma2704]

@johnyip  : yes, that was the case. I tried earlier and figured out I had blanks. 
Thanks for your response.