Return Customer Age - Power Query Editor Tips and Tricks
Pragmatic Works Pragmatic Works
213K subscribers
1,394 views
0

 Published On Apr 10, 2024

In this video, we will learn how to convert a date/time value into a date, which isn't always as easy as it sounds! We will also learn how to use Power Query to calculate the age of returning customers. We will go through step-by-step instructions on how to extract the date of birth from customer data and calculate their age based on the current date. This will enable you to better understand your customer base and make informed decisions based on their age demographics.

👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit https://prag.works/MITCHELL40 for 40% off On-Demand Learning!
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt

🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/

Let's connect:

✔️Twitter: https://prag.works/yt-twitter
✔️Facebook: https://prag.works/yt-fb
✔️Instagram: https://prag.works/yt-insta
✔️LinkedIn: https://prag.works/yt-li
✔️Discord: https://prag.works/yt-discord

Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#pragmaticworks


00:00 Intro
02:01 Handling Errors in Date Conversion
03:34 Importance of Adding Steps in Date Conversion Process
05:10 Creating Customer Age Column Using UI in Power Query Editor
06:40 Utilizing Additional Functions in Power Query Editor
09:41 Exploring Further Functionality in Power Query Editor

show more

Share/Embed