display INT as a well formatted date SSAS?

[Anonymous]

I am consuming LIVE from an SSAS cube.

I have my Fact table with the below column:

When I display it in a matrix visual, in my pbix I get this:

But in SSAS I see it as:

How can I display it in a nice dd-MMMM-yyyy format?

Ps: the table comes from a ‘sql server’ source with INT data type.

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Please try:

Output:

Then create a measure to replace the date

Measure = 
var _year = VALUE(LEFT(MAX('Table_1'[Date]),4))
var _month = VALUE(RIGHT( LEFT(MAX('Table_1'[Date]),6),2))
var _day = VALUE(RIGHT(MAX('Table_1'[Date]),2))
return  FORMAT( DATE(_year,_month,_day),"dd-mmmm-yyyy")

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.