Changing year column to dd.mm.yyyy column

[Fahid]

Hello everyone,

I have a year column in a table where if I change its data type to date format it changes all the year values. I tried to make that year column dd.mm.yyyy format by using below DAX but I can’t change data type here to date format.

DATE = "1.1."&'Export'[Year Built, Year]

I need to make that year column as 1.1.yyyy format and data type should be date as I want to use time intelligence function. Could you please help me to solve this problem?

BR,

Fahid

[itsmebvk · Accepted solution]

@Fahid create a calculated column using following formula > Then change Date Format as highlighted in below screenshot

Column = DATE(Sheet1[Year],1,1)

If I misunderstood your requirement, please elaborate your requirement.

[Fahid]

Hello,

@itsmebvk Thanks a lot man. Your code works perfectly.

BR,

Fahid