You should use power query to convert text into dates in power bi, but if you have a direct query or live connection and you need to do it in DAX, here is a tutorial of what works, what doesnt and what to watch for.
Enjoy!
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: curbal.com
Contact us: curbal.com/contact
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
curbal.com/product/sponsor-me
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
- DAX Fridays! #181: Can't covert text into dates using DAX Here is why... ( Download)
- DAX Fridays! #183: Virtual relationships with INTERSECT ( Download)
- Easily Fix Dates Formatted as Text with Power Query ( Download)
- Unable to Change Date Format in PowerBI Watch this | PowerBI Tutorial | MI tutorials ( Download)
- DAX Fridays! #182: Why your Power BI tables sometimes filter, sometimes dont ( Download)
- Power Query Basic 11 - Convert Date Text into Date ( Download)
- DAX Fridays! #171: Distinctcount with blanks ( Download)
- Change Numbers to Date Format in PowerBI | MiTutorials ( Download)
- Convert a number column into a date column in Power BI ( Download)
- Create a DateKey YYYYMMDD format using DAX Format Function Power BI ( Download)
- 4 Ways to Fix DATEFORMAT ERROR in Power BI Desktop // Beginners Guide to Power BI in 2021 ( Download)
- how to convert numbers into text in power bi desktop | real time dax functions ( Download)
- Convert Text to Date | DATEVALUE Function | Text to Columns | Power Query ... and more ( Download)
- DAX Fridays! #197: Why you need to test your DAX measures in different contexts ( Download)
- Convert Integer value to Date format in Power BI | Power BI for beginners ( Download)
