For Data: I have imported a .CSV file.
I have two questions?
How can I change the date format to the desired format?
2.Another column has date in DD/MM/YYYY (27/08/2016) format but PowerBI is reading it as Text.
Some cells have blank data.
This is my first question, please pardon me for the language.
Thank you for the help.
Go to Solution.
@sanchit This is controlled by the Locale Setting!
MM/DD/YYYY is the US format (and maybe some other countires not sure???)
But your csv file likely came form a place where they use DD/MM/YYYY
To have PBI recognize those as dates Go to File => Options and settings => Options => Locale => change to your country/region
View solution in original post
@Sean Thank you so much It worked.
I was trying it with DAX but in vain , is there a way to solve it using DAX , manually adding a new column with a different date format.
@sanchit Probably easiest way would be in the Query Editor
Split Column => by delimiter => Custom "/" at each occurence
And then Merge those columns in the "correct" order.
That should work!
@Sean I will try that . Thanks
@sanchit Here are the steps to convert DD/MM/YYYY to MM/DD/YYYY
Another way of doing:
In Power Query Editor, right-click on the column header / "Change Type" / "Using Locale..." / then choose Date format with the locale you want
hi @sanchit what locale setting did you use? i need the dd/mm/yyyy option as well
How do we change only the column header to date format and the data to be in the number format?
How do we change the format of the column header to date format and remaining data to be in number format?
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!