Forum Discussion
Change Data format in table as a calculated column
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.
Hi Anonymous ,
Agree with johnt75 , add another FORMAT function to get the expected result.
Add another FORMAT function to get the desired resultBest Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
Agree with johnt75 , add another FORMAT function to get the expected result.
Add another FORMAT function to get the desired resultBest Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
johnt75Super User
Try
Date col = DATE ( LEFT ( 'Table'[Date as integer], 4 ), RIGHT ( 'Table'[Date as integer], 2 ), 1 )