Forum Discussion

AleFVG's avatar
AleFVG
Helper I
5 years ago
Solved

Transform date field

in the excel file that I import into power bi there is a date field in the month-year format example 12019 (january 2019) 122019 (December 2019) 42020 (April 2020) I have to transform this f...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    AleFVG , You can create a date like this

     

    date = date(right([col],4) , left([col], len([col])-4),1)

     

    now you can convert to format from Column tools or format commnad

     

    Text date = format([date], "DD/MM/YYYY")

     

    Please provide your feedback comments and advice for new videos
    Tutorial Series Dax Vs SQL Direct Query PBI Tips
    Appreciate your Kudos.

AleFVG's avatar
AleFVG
Helper I
5 years ago

thanks for the support amitchandak !

I created a new column, and entered the formula you suggested.

Error displayed below:

Expression.Error: The name "date" was not recognized, please check orthography.

 

When I enter the formula, it confirms that there are no syntax errors.

AleFVG's avatar
AleFVG
Helper I
5 years ago

Sorry amitchandak !

Your solution works!
I was trying to insert the formula into the data model, and it doesn't work!
I tried to insert it in the table and it works!

 

many thanks.