Contrary to popular belief, working on files online can be trouble-free. Sure, some file formats might seem too hard with which to work. But if you get the right solution, like DocHub, it's easy to tweak any file with minimum effort. DocHub is your go-to solution for tasks as simple as the ability to Mix Date Format For Free a single file or something as daunting as processing a huge stack of complex paperwork.
When it comes to a solution for online file editing, there are many solutions available. However, not all of them are robust enough to accommodate the needs of people requiring minimum editing capabilities or small businesses that look for more advanced tools that allow them to collaborate within their document-based workflow. DocHub is a multi-purpose solution that makes managing documents online more simplified and smoother. Try DocHub now!
recently I have got similar query from a couple of customers about a date column where they have inconsistent dates if you look at this example few dates are month and day and your dates are date and month based on the local Regional settings in your computer only one date will be considered as a proper date and the second date will be considered as a text gig and when you convert this into a data type in power bi it will throw an error so the question is how to resolve it without having much manual intervention now let me show you what exactly happens when I take this column inside power bi so let me jump into power bi transform data then new source Excel selecting the sheet1 where the data is there and okay now this is the column now this column is having the different formats what is my local original setting is month date so whatever date is here consisting month date will be considered as a proper date another date will throw an error let me show you how it happens first let me r