Forum Discussion

montiell's avatar
montiell
New Member
5 years ago

Extract date from a column with date time

Hello team,   I am practically still new with power bi dax formulas and I am trying to accomplish to create a new colum or date hirearchy. My current colum data is format as follow:   11/26/2020 ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

montiell  Hey mate ,
you have to convert date to date format first as it is a text feild right now .

"Completed-MonthYear = FORMAT([DATACOLUMN],"m/dd/yyyy") but it didnt work, I got the erros message:
 
Cannot convert value '' of type Text to type Date. I tried converting the date from DATACOLUM into date but i got the same error msg."

first convert /format it is as a date coloum then use your formula it will work.
 
Completed-MonthYear = FORMAT([DATACOLUMN],"m/dd/yyyy")
 
 
it will work thank you 
  • montiell's avatar
    montiell
    New Member
    5 years ago

    I think you are right, but Everytime i tried to converted i receive the following msg:

     

     

    I think is because my date include the time zone:

     

     

    and after the error of the formula this appears on my calculated column:

     

     

    I think If i can resolve the issue with the data type and be able to converted as date it will get fix, sadly i keep receiving the same error everytime 😕