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!

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , do you have all values as number , that can days from 1-1-1970 or 1-1-1900

 

Date =date(1900,1,1) + [Days]

 

or

Date =date(1970,1,1) + [Days]

 

or

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Amit,

     

    My date field contains below values.Could you please suggest to format as mm/dd/yyyy

     

     

    Thanks