July 28, 2024 Rick de Groot Power Query 8 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
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 8 Understanding Records in Power Query M Records serve as one of the structured values in Power Query. ... Read more
