Forum Discussion
convert to date format
Hi, I am getting below error in date column. could you please help to convert to date format (mm/dd/yyyy) "power bi DataFormat.Error: We couldn't parse the input provided as a Date value. Detail...
Hi, Anonymous
column:
Column = IFERROR(FORMAT(('Table'[Column1]-DATE(1899,12,30))+DATE(1899,12,30),"mm/dd/yyyy"),BLANK())measure:
Measure = IFERROR(FORMAT((MAX('Table'[Column1])DATE(1899,12,30))+DATE(1899,12,30),"mm/dd/yyyy"),BLANK())result:
Zerrick
Did I answer your question? Mark my post as a solution!
Thank you Zerrick.
Below expression works for me but encounter errors "Cannot convert value '' of type Text to type Number." when column has "" or "N/A". Could you please help me to fix
Column2 =
var _1=([Column1]-DATE(1899,12,30))+DATE(1899,12,30)
return FORMAT(_1,"mm/dd/yyyy")
Hi, Anonymous
column:
Column =
IFERROR(FORMAT(('Table'[Column1]-DATE(1899,12,30))+DATE(1899,12,30),"mm/dd/yyyy"),BLANK())measure:
Measure =
IFERROR(FORMAT((MAX('Table'[Column1])DATE(1899,12,30))+DATE(1899,12,30),"mm/dd/yyyy"),BLANK())result:
Zerrick
Did I answer your question? Mark my post as a solution!