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 All,
I have a date column with the Date values as "Jul-17","Aug-17",....."Dec-18". This is by default coming in as string format and we will have no control of changing the format of it. How can I change the format to "MM/DD/YYYY" for this?
Thanks
Prash
@prduddu,
Please click the date column in the Fields panel, then click on Modeling in the Desktop ribbon and change data type of the column to Date and change date format to MM/dd/yyyy.
Regards,
Create a calculated column... and try this...
Column = FORMAT(Table1[Column1],"MM/DD/YYYY")
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |