Rick de Groot Power Query 0 The Let Expression in Power Query M The let expression in Power Query is one of the first ... Read more
December 18, 2024 Rick de Groot Power Query 2 How to Convert a Data Type to Text in Power Query M Power Query has many different data types, like text, numbers, tables, ... Read more
November 15, 2024 Rick de Groot Power Query 3 How to Replace Multiple Substrings in Power Query M Power Query has functions to replace substrings. You can think of ... Read more
September 11, 2024 Rick de Groot Power Query 5 Understanding Semi Joins in Power Query M This article delves into the Left Semi Join and Right Semi ... Read more
October 23, 2024 Rick de Groot Power Query 1 Creating a 445 Calendar (incl 454, 544) in Power Query M This article delves into how to create a 445 calendar in ... Read more
July 5, 2024 Rick de Groot Power Query 2 Using Variables in Power Query M In programming, variables allow you to store the result of an ... Read more
September 11, 2024 Rick de Groot Power Query 0 Convert Unix Timestamp to Datetime in Power Query M A UNIX timestamp is a number of seconds since 00:00:00 UTC ... Read more
June 30, 2024 Rick de Groot Power Query 0 Extracting Year, Month, or Day from a Date in Power Query The date column is the foundation when working with calendar tables ... Read more
August 2, 2024 Rick de Groot Power Query 3 Dynamic Group By Operations in Power Query M The Table.Group function in Power Query summarizes columns and lets you ... Read more
December 30, 2024 Rick de Groot Power Query 4 Using Custom Comparers with Table.Group in Power Query The Table.Group function in Power Query allows you to summarize your ... Read more
April 24, 2024 Rick de Groot Power Query 1 Mastering M: Which Power Query Functions to Learn and When The Power Query M language features nearly 1000 unique functions, which ... Read more
May 2, 2024 Rick de Groot Power Query 3 SWITCH Function (Multiple If Statements) in Power Query The typical control structure used in Power Query is the if-statement. ... Read more
