Documenting the tips, tricks, and tools that I picked up while working in a Microsoft GCC environment for nearly 15 years.
I have finally decided to get this Power Query TnT written down before I forget all about it for the 80-bazillionth time. This one covers how I quickly transform a list of Records into a Table of correctly typed columns, all in a single Power Query M action step! The Problem I get so frustrated…
The number data type is oh so useful, let me just count the ways! I kid, but not about the usefulness. This post is about numbers, but I want to clarify that I’m only talking about whole numbers (or integers), decimals, fractions, floating point, and currency, both positive and negative. According to the Microsoft documentation,…
I thought a post about text data would be easy to write up, and I was wrong. I have struggled with writing and re-writing this post. Mostly because of the simplicity of this data type mixed with the complexity of manipulating it. Regardless, I do want to start with the definition from Microsoft. According to…
Color can be a tricky thing, but it’s also one of my favorite topics to explore. So, what if you happened to be looking through Microsoft’s data type documentation for an explanation on color. You might be left wondering if they even really tried. I know I am. A color specification, including an alpha channel.…
Also known as True/False, Yes/No, On/Off, Active/Inactive, Enabled/Disabled, and many others. At the heart of it all, boolean is simply a binary of 1 or 0. The boolean data type is: A true or false value. Can be used directly in If, Filter and other functions without a comparison. Microsoft Learn Documentation But what does that actually mean, and how is it…
