Forum Discussion

reije021's avatar
reije021
Frequent Visitor
7 years ago
Solved

int64.type to date

When I import a excel sheet with date columns (photo1)and the query editor  Power BI  imports them as int64.type (photo 2) + (photo3) When I convert this type to date I get an error. Who has an so...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI reije021,

     

    AFAIK, current you can only convert numeric value (e.g. yyyymmdd) to date value, it seems like power query not support direct analysis total days number to date type.

     

    For this scenario, you can try to convert them in data view or add custom column to reference and format.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI reije021,

 

AFAIK, current you can only convert numeric value (e.g. yyyymmdd) to date value, it seems like power query not support direct analysis total days number to date type.

 

For this scenario, you can try to convert them in data view or add custom column to reference and format.

 

Regards,

Xiaoxin Sheng