August 8, 2025 Rick de Groot Power Query 2 Enter Data in Power Query M: From Table to Binary and Back Have you ever pasted a small table into Power Query using ... Read more
May 22, 2025 Rick de Groot Power Query 2 Converting HEX to RGB Values in Power Query M Say you’re working in Power BI and have a main color ... Read more
May 22, 2025 Rick de Groot Power Query 0 Convert RGB to HEX in Power Query M You’ve picked colors for each product category and want Power BI ... Read more
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 3 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
January 30, 2025 Rick de Groot Power Query 5 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 6 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 5 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
