Forum Discussion
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 solution
photo1
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
1 Reply
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