Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • zzcc's avatar
    zzcc
    5 years ago

    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!

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

You can add a custom column (or adapt a transform column step) with this formula

 

= try Date.From([Date]) otherwise Date.AddDays(#date(1900,1,1), Number.FromText([Date]))

 

Pat

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you Pat. Your expression works well but when date column has some text values(N/A..) it shows error

 

Suren