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
August 28, 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 0 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 2 Dynamic Group By Operations in Power Query M The Table.Group function in Power Query summarizes columns and lets you ... Read more
June 20, 2024 Rick de Groot Power Query 6 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
July 28, 2024 Rick de Groot Power Query 7 Perform Join Based on a Date Range in Power Query M Some datasets contain information that is only relevant between two dates. ... Read more
August 21, 2024 Rick de Groot Power Query 2 Remove Milliseconds from Time Values in Power Query M Time values in Power Query comprise not only of hours, minutes ... Read more
May 14, 2024 Rick de Groot Power Query 2 Enumerations in Power Query M In programming, enumerations are a commonly used concept. You can picture ... Read more
