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.
Hi Guys,
I am having an issue with date format as some of the columns are yyyy/mm/dd 00:00:00 and others are like yyyy-mm-dd 00.00.00
I could change the first format to show only dates yyyy/mm/dd, but when I try to change the format for the other columns to date only it gives me an error. is there any way to fix that?
Thank you
Solved! Go to Solution.
Hi @Hamidrezaei ,
If you only want the date, you could split this column based on space.
Here is my test result.
Now you could remove another time column or transform it, it is up to you.
Hi @Hamidrezaei ,
If you only want the date, you could split this column based on space.
Here is my test result.
Now you could remove another time column or transform it, it is up to you.
Hi @Hamidrezaei
replace the . with with : and it should work with both yyyy-mm-dd 00:00:00 and yyyy/mm/dd 00:00:00
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
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.