Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Function: Converts different date formats into YYYY-MM-DD or any other format that you define. You define it in code, it executes! Date column with mixed date formats Usage: = ConvertToISODate("03/13/2025") → Returns: "2025-03-13" let ConvertToISODate = (inputDate as any) as nullable text => let ConvertedDate = try Date.ToText(Date.From(inputDate), "yyyy-MM-dd") otherwise

Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Function: Extracts only the numeric values from a given text. Simply add custom function in Power Query and define your column. Add a new Query from Sources Usage: = ExtractNumbers("Order ID: 123ABC456") → Returns: "123456" Power Query code for use and reuse: let ExtractNumbers = (inputText as nullable text) as nullable text => let NumbersOnly = if inputText = null the

Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Function: This function, RemoveSpecialChars, cleans a text string by removing special characters, retaining only letters and numbers. Add fx to the blank query (Advanced Editor) Usage Example: Using = RemoveSpecialChars("H3ll0! W@rld#") will return "H3ll0 Wrld". The function removes specified special characters from the input text, ensuring a clean output. Power Query code for use and reuse: Rem

This Power Query function dynamically generates a calendar table based on a given start date, end date, and fiscal year start month . It is designed to support time-based analysis in Power BI by including key date attributes, fiscal calculations, and various helper columns. Check out some of our FREE templates and materials. PRACTICE MATERIAL BELOW!👇 Power Query Calendar Function diagram illustrating parameter inputs for start date, end date, and fiscal start month, with