Solution to Challenge-21| Power Query M | LET|TEXT.LENGTH|TEXT.START|TEXT.MIDDLE|TEXT.END|#TIME

Solution to Twenty First (21st) Challenge with Excel Power Query M Code

🔍 Excel Challenge 21 Solution | Dynamic Time Conversion Using Power Query M

In this video, I solved an interesting Power Query challenge by converting dynamic string values into custom time format.

Topics covered:
• Dynamic text extraction
• Power Query indexing logic
• Helper columns
• LET variables in M language
• Creating custom time using #time()

A practical example for improving your Power Query problem-solving skills.

Download Excel File:
https://1drv.ms/x/c/F66A2644F1B4537C/IQACUfyo3q8TSKuzHc998j4WAb2Zxbxk2pQdok2lFTfst2Y?e=nP2GyZ

LinkedIn Post:
https://www.linkedin.com/posts/excelmdshahalam_excel-challenge-21-change-the-time-format-activity-7280152568767332352-fIO_?utm_source=share&utm_medium=member_desktop

Download Free eBook:
https://www.shahalamanalytics.com/newsletter/ebook/

YouTube Channel Link:
https://www.youtube.com/@ShahAlamAnalytics
The next will be Solution to Twenty Second (22nd) Challenge with Excel 365 Dynamic Array Formulas

I appreciate your understanding of any mistakes I made—please focus on learning and enjoy the video.
Please follow our Social Media:
https://www.linkedin.com/in/shahalam-analytics-excelbi/
https://www.facebook.com/ShahAlamDataTrainingAnalytics/
https://www.shahalamanalytics.com/

@ShahAlamAnalytics | Md Shah Alam | Microsoft Certified Trainer | Excel | Power BI

Видео Solution to Challenge-21| Power Query M | LET|TEXT.LENGTH|TEXT.START|TEXT.MIDDLE|TEXT.END|#TIME канала ShahAlam: Data Training & Analytics