top of page

BLOGS


Power Query: Rename Columns from a Mapping Table (Inline step)
Function: Would you like to rename multiple columns in a single operation? This custom step allows you to rename as many columns as...

MirVel
Apr 191 min read


Power Query: Extract Numbers from a Text String
Function: Extracts only the numeric values from a given text. Simply add custom function in Power Query and define your column. Add a...

MirVel
Mar 131 min read


Power Query: Remove Special Characters from Text
Function: This function, RemoveSpecialChars, cleans a text string by removing special characters, retaining only letters and numbers....

MirVel
Mar 131 min read


Power Query: Reusable Calendar function
This Power Query function dynamically generates a calendar table based on a given start date, end date, and fiscal year start month ....

MirVel
Mar 32 min read
bottom of page