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.
This should be easy but being new to PowerBI I haven't found out how to do it yet. I have a column in a SQL Server table that I'm importing that contains a DateTime. I need to decompose this into two seperate columns, one that holds the date and another that holds the time.
Solved! Go to Solution.
In the query editor, you find Date and Time options at the right hand side of both the "Add Column" tab and the "Transform" tab. These options include extracting date only and time only. They are available only if you first select your date/time column.
So you might add a column with time only and then transform the original column to date only.
In the query editor, you find Date and Time options at the right hand side of both the "Add Column" tab and the "Transform" tab. These options include extracting date only and time only. They are available only if you first select your date/time column.
So you might add a column with time only and then transform the original column to date only.
Thanks!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |