April 22, 2024 Rick de Groot Power Query 8 Date Formatting in Power Query – Master 18 Custom Formats Date formatting is a frequent task in Power Query’s M language. ... Read more
November 21, 2023 Rick de Groot Power Query 0 Understanding Expression Syntax Errors in Power Query M Expression Syntax Errors occur when there’s a mistake in how you ... Read more
February 23, 2024 Rick de Groot Power Query 9 Understanding Records in Power Query M Records serve as one of the structured values in Power Query. ... Read more
November 21, 2023 Rick de Groot Power Query 7 Creating Multiple Running Totals (in Bulk) in Power Query Have you ever found yourself scratching your head over how to ... Read more
November 21, 2023 Rick de Groot Power Query 0 Remove List Items by Positions in Power Query Once you get acquainted with Power Query, you will work with ... Read more
February 23, 2024 Rick de Groot Power Query 6 3 Ways to Select List Items by Position in Power Query Retrieving specific items from a list based on their position is ... Read more
February 23, 2024 Rick de Groot Power Query 1 How to Use Wildcards in Power Query M (6+ Examples) Wildcards are characters that help you easily filter specific texts. They ... Read more
November 21, 2023 Rick de Groot Power Query 0 Understanding Recursion in Power Query: Tower Of Hanoi This post introduces a fun puzzle that perfectly illustrates the concept ... Read more
July 4, 2024 Rick de Groot Power Query 3 Power Query M vs SQL: A Balanced Perspective So you’re trying to decide between learning Power Query M vs ... Read more
April 28, 2024 Rick de Groot Power Query 3 Removing Excess Spaces Between Words in Power Query Removing excess spaces between words is not easy in Power Query. ... Read more
November 17, 2023 Rick de Groot Power BI 0 Understanding Measures vs Calculated Columns in Power BI Measures and calculated columns are important components that allow you to ... Read more
July 4, 2024 Rick de Groot Power Query 18 How to Remove Duplicates in Power Query (Step-by-Step) In this article, we’ll explore how to remove duplicates in Power ... Read more
