4 Ways to Fix DATEFORMAT ERROR in Power BI Desktop // Beginners Guide to Power BI in 2021

[@EmmanuelRLau]

I was extremely frustrated because was not able to found the cause, but this was so simple and just THANK YOU

[@rahulrshimpi]

Was stuck 45 mins solving the problem, you sorted bro

[@SolutionsAbroad]

You're welcome, thanks for watching!

[@kartik-wi2jv]

Excellent way of explanation.. your time and effort are really appreciated.. Thanks for sharing..

[@SolutionsAbroad]

You're welcome, thanks for watching!

[@JenzUrq]

Awesome man! Beginner here, definitely worth subscribing!

[@SolutionsAbroad]

Great to hear, thanks for the sub!

[@alexotoous]

hey good video, but when you changed the date to US local the formate didn't change. Look at the first row it's 27/01/2021 which US month is 27 if the US format is MM/DD/YYYY . any clarifications? thank you

[@FarkadBarri]

Thank you so much for such a detailed creative ways to solve this issue, now I have 3 different ways to handle such an error , plus the detailed dax option is very well explained !

[@hectormiguelvinuezabarroso3967]

Thanks a lot, with your video I solved my problem to deal with dates so fast.

[@mohammedansar2840]

Your explanation is top notch

[@simranverma04]

Thank you! Such an easy fix!

[@idaraokposen7444]

Hi, thank you. The first method worked.

[@hailelove1]

very excellent way of presentation. thank you give me a solution for my lock

[@prakhartiwari4221]

It worked.. Thanks for sharing!

[@SolutionsAbroad]

You're welcome!

[@krispinatitis6986]

Terima kasih. Video anda sudah membantu saya. God Bless you

[@srikanthbabu419]

Thank you so much for the video 🙏. My problem got resolved with this.

[@kiran4059]

Have a ques sir i downloaded a pbix file in online i want to analyze that data in excel but am unable to do so.If i click on edit query of a table it gives me an data source error. so how can i access the source data of that file for practice purpose.

[@SolutionsAbroad]

Hi, what error do you get?

[@norpriest521]

Thank your sir.
By the way, have you come across Expression.Error - we cannot convert value 0 to type Text?
I ran into this error after I merged the 2nd table. The merge went good. Nothing wrong with it.
But when I tried to Close and Load back to Excel, that error showed up.
I still can't fix it so far.
Do you have some suggestions on this. Thank you.

[@sagarranpise9955]

Thanks a lot for this information, helped me solve my date_time_error

[@subhapriyasanki5241]

very good brother

[@bharathkumarthatikonda4982]

Thanks for making this video

[@SolutionsAbroad]

You're welcome!

[@goldr0x]

Thank you!!

[@bishowbudhamagar970]

thanks man life saver

[@devendradhonde7207]

Thank you very for the video. 🙏

[@SolutionsAbroad]

My pleasure!

[@sinchanacp8842]

Thank you 👍

[@debbyskitchen_by_funmi]

What if you don't have delimiter but you have numbers in form of text or decimal that you want to change to proper date/time format.

[@nexsusninja9343]

Thanks Brother

[@bodyart1460]

thank you so much bro

[@ramanmishra2698]

Thanks..

[@jagadeeshpinninti]

Is it possible to achieve number in India format like 26,35,76,83,635

[@SolutionsAbroad]

Hi, it should be possible if you use the India locale (using step 2) Hope it helps!

[@Ashu23200]

what if there is a mix pattern of dates like 33334 and 12/7/2012 and 11-4-1967 in text datatype

[@jyotipatil5146]

Thank you so much😊

[@oluwasegunraimi3453]

Insightful

[@karthikk8257]

Thankss

[@JavedAlam-ip9hp]

I have column with dates and spaces ( ) and could not able to refresh the sheet. How can I fix this error?

[@neeelababu3247]

First, Replace the spaces with nothing. That gets sorted

[@ksenalevittepayot1666]

nimal thanks.......

[@renukamatkar2093]

Hello, date slicer format is changing in power bi service. I have also changed date using locale. Still the issue is same. Can anyone please suggest a solution

[@learn_techie]

solu?

[@lamboavancher]

Thanks a loat

[@hw6892]

Dear sir, why i converted whole number to time always shows error, especially 2400 is error every time?😢

[@ayoolaaguda]

Thank you very much