Create Date in custom column

Question

Good Afternoon!&nbsp;I created a custom column in DAX as such:&nbsp; "7/1/" &amp; sheet1[fyear].&nbsp; 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).&nbsp;&nbsp;Can someone provide a solution or assist me in formatting or converting this column to date format?&nbsp;&nbsp;&nbsp;Thank you.

anonymous · Accepted Answer

you will need to use the Date functionhttps://docs.microsoft.com/en-us/dax/date-function-dax

Forum Discussion

Create Date in custom column

2 Replies

Related content

Creating a custom column

create custom column concatenated

Creating Custom columns

Creating custom columns keeps returning a structured Table column

Create a custom column