Geek Logbook

Tech sea log book

Splitting Strings in Excel: A Simple Guide

When working with Excel, you may encounter situations where you need to split a string into separate parts. For example, consider the following string: If you want to separate orderId and the actual ID value, there are several methods available depending on your Excel version. Method 1: Using TEXTSPLIT (Excel 365/2021) If you’re using the

Generating a Calendar Table in Power Query (M Language)

When working with Power BI or other Power Query-supported tools, having a well-structured calendar table is essential for time-based analysis. In this blog post, we will walk through an M Language function that generates a comprehensive calendar table. Why Use a Calendar Table? A calendar table provides essential time-based fields such as year, quarter, month,