Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
For example : if you have a date dd/MM/yyyy. follow the steps
1. Edit the table
2. Split the column with '/' custom delimiter
3. Re-arrange the columns to see the month in first and date column to next and year to the last.
4. Select all the three columns.
5. Right click-> Merge columns with a custom delimiter '/'.
6. Transform the column to change the data type to 'Date'
Finally you see the column transformed. Its easy. Try it by yourself.
Solved! Go to Solution.
Hi @gpraveenonline,
Thanks for your sharing.
Thanks,
Lydia Zhang
If you're dealing with some clients that use mm/dd/yy and others that use dd/mm/yy, I would suggest that you just use the format: "17-Mar-16" instead of either dd/mm or mm/dd to avoid confusion among your clients. It is an available date format in PowerBI.
I had a similar situation where the data was in the "dd.mm.yyyy" format so Power Query could not covert it into a date format. I created a custom column:
If you're dealing with some clients that use mm/dd/yy and others that use dd/mm/yy, I would suggest that you just use the format: "17-Mar-16" instead of either dd/mm or mm/dd to avoid confusion among your clients. It is an available date format in PowerBI.
Hi @gpraveenonline,
Thanks for your sharing.
Thanks,
Lydia Zhang
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
84 | |
69 | |
68 | |
39 | |
37 |