Change Data format in table as a calculated column

[Anonymous]

Hi Experts 

My date format in a Table is 201905 (text) - i would like this to be show as may 2019 - i cannot do this in Power Query as i have no access to the DB. Need to be done as a calculated column measure.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Agree with @johnt75 , add another FORMAT function to get the expected result.

Add another FORMAT function to get the desired result

Best Regards,

Stephen Tao

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

[johnt75]

Try

Date col =
DATE ( LEFT ( 'Table'[Date as integer], 4 ), RIGHT ( 'Table'[Date as integer], 2 ), 1 )