Function:  Would you like to rename multiple columns in a single operation? This custom step allows you to rename as many columns as...

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 text) as text => let NumbersOnly = Text.Select(inputText, {"0".."9"}) in NumbersOnly in ExtractNumbers Choose your column with a text/number to clean (

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 operates by removing specified special characters from the input text, ensuring a clean output. Power Query code for use and reuse: RemoveSpecialChars = (inputText as text) as text => let C

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. Power Query Calendar Function diagram illustrating parameter inputs for start date, end date, and fiscal start month, with outputs like date, fiscal year, ISO week, and day classifications such as weeke