error converting text to date

[YBZ]

Hi all,

I have an error with below sample data to convert a text column (Period) to a date format (Date period).

Period	Date period
004.2021	01.04.2021
005.2021	01.05.2021
006.2021	01.06.2021

The Date Period I retrieved via following formula : 
Date Period = CONCATENATE("01.";right('DataFile'[Period];7))

Now when I would like to convert the Date Period column to date (dd.mm.year), it says that it cannot convert the value to Date format.

Any support is much appreciated,

Kind regards

[Greg_Deckler · Accepted solution]

@YBZ Perhaps try:

Date column =
  VAR __Day = LEFT([Date period],2)
  VAR __Month = MID([Date period],4,2)
  VAR __Year = RIGHT([Date period],4)
RETURN
  DATE(__Year,__Month,__Day)

[YBZ]

thanks Greg, it works! 🙂