How to convert integer (112 format) in to date using Dax formula?

Question

How to convert integer (112 format) in to date using DAX formula?

The date is in integer format 20170727 and I want to convert it to the following 27/07/2017.

Solution 1

= DATEVALUE(FORMAT(Date[DateKey], "0000/00/00"))

Solution 2

One way to get this in pure DAX is:

=DATE(INT(LEFT([IntegerDate],4)),INT(MID([IntegerDate],5,2)),INT(RIGHT([IntegerDate],2)))

Replace IntegerDate by the actual name of your integer date.

However it is better perform this transformations using PowerQuery or a data integration tool of your preference.

Let me know if this helps.