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.
The data that I am using is importing as the following form "MM:DD:YYYY 00:00:00 __". (For example, "10/1/2015 12:00:00 AM".) I am not sure why it is doing this because the source of the data is simply in MM:DD:YYYY format. (I am importing this data from a SharePoint site, FYI.) How do I separate the date (MM:DD:YYYY) from the timestamp on the right side (00:00:00 __)? In the end, I am trying to zero in on the year, month, and quarter using a fiscal calendar but am unable to create the relationship between that calendar and the dates because of the timestamp attached. Suggestions?
Solved! Go to Solution.
Edit your query, select your column, go to the Transform tab and change the "Data Type" to Date instead of Date/Time.
Column = Table[date].[Date]
Or you can use Format() function to remove the timestamp part.
Column = FORMAT(Table[date],"MM-DD-YYYY")
Regards,
Thank you! This is exactly what I was looking for and is simple.
Edit your query, select your column, go to the Transform tab and change the "Data Type" to Date instead of Date/Time.
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 |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |