Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |