Create a new date format column in SSAS based in a int column

[Anonymous]

Hi all 
I have a dimDateEntry with the format yyyymmdd , as integer. 
But now I need to add a new date format column in SSAS, with that date.
I already try the follow code that returns a error :   =FORMAT('Table'[dimDateEntry];"mm/dd/yyyy")
or even 
=DAY('Table'[dimDateEntry]) & "/" & MONTH('Table'[dimDateEntry]) & "/" & YEAR('Table'[dimDateEntry])

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

Create a column with below code:-

Column = 
var _year = MID([Date],1,4)
var _month = MID([Date],5,2)
var _day = MID([Date],7,2)
return DATE(_year,_month,_day)

Thanks,

Samarth