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!

     

zzcc's avatar
zzcc
Frequent Visitor
5 years ago

Hi, Anonymous 

To create a measure like this:

 

Measure = (MAX('Table'[Column1])-DATE(1899,12,30))+DATE(1899,12,30)

 

or create a column:

 

col = ([Column1]-DATE(1899,12,30))+DATE(1899,12,30)

 

result:

 

Zerrick

Did I answer your question? Mark my post as a solution!

 
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you zerick.

 

But requirement is to convert this serial format(44236, 44239) to MM/DD/YYYY in query editor 

 

Suren