Create Date in custom column

[proudmama]

Good Afternoon!

I created a custom column in DAX as such:  "7/1/" & sheet1[fyear].  The result is what I expected BUT when I change the data type to Date, there is an error thrown (cannot convert value '7/1/' of type Text to type Date). 

Can someone provide a solution or assist me in formatting or converting this column to date format?  

Thank you.

[Anonymous · Accepted solution]

you will need to use the Date function

https://docs.microsoft.com/en-us/dax/date-function-dax

[proudmama]

Thank you!  Perfect.