Forum Discussion
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 ...
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.
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
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 😕