Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear all,
I'm facing a problem now as I input the data from Excel, the column "ATA" shows as Text instead of Date/Time (as "ATD) and cannot be shown as Date/Time.
But from Excel this two columns are in the same format and can even do calculations.
Any help would be appreciated.
Br,
Solved! Go to Solution.
@javieezy
The problem with the column ATA is, it has ":" at the end, do the following.
Go to: Transform > Extract > Text Before Delimiter and choose the options as I have done
Then change the column type to Date/Time.
Done
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@javieezy
The problem with the column ATA is, it has ":" at the end, do the following.
Go to: Transform > Extract > Text Before Delimiter and choose the options as I have done
Then change the column type to Date/Time.
Done
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@javieezy Can you share the file or at least the code from Advanced Editor in Power Query Editor? Almost looks like the first column is getting truncated for some reason.