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
July 28, 2024 Rick de Groot Power Query 10 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
April 30, 2024 Rick de Groot Power Query 0 The Definitive Guide to Power Query M More and more people work with data. Whether extracting data from ... Read more
February 21, 2024 Rick de Groot Power Query 0 List Multiplication by Index Position in Power Query In this article, you learn how to multiply values from two ... Read more
February 22, 2024 Rick de Groot Power Query 0 Resolving Dataformat Errors in Power Query M DataFormat errors in Power Query can disrupt the flow of data ... Read more
July 31, 2024 Rick de Groot Power Query 0 Converting Julian to Gregorian Dates in Power Query M In this article, we will look at different ways to convert ... Read more
August 18, 2024 Rick de Groot Power Query 0 Creating Julian Day Numbers with Power Query M This article shows how you can convert dates into Julian Day ... Read more
July 2, 2024 Rick de Groot Power Query 0 Mastering Custom Format Strings in Power Query M Custom Format Strings are powerful for converting your values into a ... Read more
