Channel Title: BI Gorilla Channel Description: Thanks for checking out BI Gorilla on YouTube! My name is Rick de Groot and my goal is to help professionals like you advance your skills to the next level with Power BI. I look at issues users run into and provide them with ready to use solutions so you can shape your data and make accurate decisions. 👉 Join me by subscribing and participating in the comments with your questions or thoughts. Visit my websites: https://powerquery.how - to learn all about function syntax and examples https://gorilla.bi - to get more in-depth articles and videos. Keep crushing it — talk soon! @Rickmaurinus <video> Converting Unix Timestamp to DateTime Values in Power Query M #powerquery #m #unix Description: Learn how to convert UNIX timestamps into readable date and time formats using Power Query M. The Unix Epoch is not a human readable format, but these techniques quickly turn them into a clear date(time) form. WRITTEN ARTICLE: https://gorilla.bi/power-query/convert-unix-timestamp-to-datetime/ I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #UnixTimestamps #dates #powerquery #m </video> <video> Create a Join based on Date Range in Power Query Description: This video shows two methods to create a join between tables based on a range of dates. You can buy the Definitive Guide to Power Query M here: https://geni.us/ODZl8 CONTENTS 00:00 Introduction 01:16 Data 01:55 Method 1: Date range join 08:21 Method 2: Explode dates WRITTEN ARTICLE: https://gorilla.bi/power-query/join-on-date-range/ Master Functions and Syntax in M https://powerquery.how ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #Join #powerquery #bigorilla </video> <video> Custom Comparer Function for Table.Group in Power Query M Description: The Table.Group function supports custom comparer functions. These allow you to define your own logic for forming groups. In this video you learn how these work and how you can build your own custom comparer function. WRITTEN ARTICLE: https://gorilla.bi/power-query/table-group-custom-comparers/ I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:25 Comparer Functions 02:35 Build a Custom Comparer Function 06:04 Summarize Dates by Quarter 08:47 Multiple Columns Logic 16:53 Simplified Comparers with GroupKind.Local LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #comparerfunctions #groupby #m </video> <video> Introducing Power Query How (Master the M language) Description: PowerQuery.How is a website that provides M language documentation. You can find functions, syntax, enumerations and lots of examples. You can find the website here: https://powerquery.how/ I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:51 Navigation 02:20 Overview pages 03:32 Motivation for website 03:56 Search Menu 05:05 Updated Articles 05:40 Code Boxes and Formatting 06:39 References: Related Functions 07:24 References: Articles 08:19 References: Enumerations 10:03 Contributions LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #powerqueryhow #powerquery #m </video> <video> Concatenate values in Power Query M | Avoid these pitfalls! Description: Concatenating values is a fundamental skills when transforming data. And doing that is straightforward for text values. But doing so while mixing data types or including null values is a bit tricker. After this video, you will know what's important, and how to make your expressions error proof. WRITTEN ARTICLE: https://gorilla.bi/power-query/concatenate-values/ I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:27 Combining text 01:53 Combine text with delimiters 03:39 Using List.Accumulate 04:26 Combining null values 08:13 Working with dates LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #concatenation #powerquery #m </video> <video> Mimic a SWITCH function in Power Query using Record.FieldOrDefault Description: The SWITCH function allows users to map input values to corresponding output values. In this video, you learn how to apply this concept in Power Query by using Record.FieldOrDefault You can buy the Definitive Guide to Power Query M here: https://geni.us/ODZl8 WRITTEN ARTICLE: https://gorilla.bi/power-query/switch/ Master Functions and Syntax in M https://powerquery.how ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:19 The manual way 01:47 Understanding SWITCH 02:29 Using Record.FieldOrDefault 05:52 Taking a table as input LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #switch #powerquery #bigorilla </video> <video> Make your Group By Operations Dynamic in Power Query M Description: Grouping data using the user interface hardcodes both column names and types. When your data changes, you then risk running into errors. This video shows different strategies to make your query logic dynamic and prevent errors. WRITTEN ARTICLE: https://gorilla.bi/power-query/dynamic-group-by-operations/ I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:29 Issue 1: hardcoded columns and types 03:04 Combining Tables 07:05 Scenario 2 08:21 Creating a Table Type 13:28 Issue 3: Expanding Hardcodes Columns 13:48 Dynamically Expand Columns LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #dynamic #groupby #m </video> <video> Creating a SWITCH Function with Conditions in Power Query M Description: The SWITCH function allows users to provide multiple conditions and return the corresponding value when one of these evaluates to true. In this video, you learn how to apply this concept in Power Query. You can buy the Definitive Guide to Power Query M here: https://geni.us/ODZl8 WRITTEN ARTICLE: https://gorilla.bi/power-query/switch/ Master Functions and Syntax in M https://powerquery.how ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:33 Scenario 01:02 List of Conditions 03:35 Retrieving Conditions and Results 05:21 Find and return the first true condition 08:24 Setting up default value logic 12:16 Applying logic to column 12:57 Create a custom SWITCH function LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #switch#powerquery #bigorilla </video> <video> Understanding Enumerations in Power Query M Description: Enumerations allows you to provide instructions to functions in a readable way. In this video we delve into what enumerations are, how you can apply them and what they are syntax sugar for. You can buy the Definitive Guide to Power Query M here: https://geni.us/ODZl8 WRITTEN ARTICLE: https://powerquery.how/enumerations/ Master Functions and Syntax in M https://powerquery.how ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #enumerations #powerquery #bigorilla </video> <video> Formatting Dates with Custom Format Strings in Power Query M Description: You can format your date with custom format strings. In this video I show you how. WRITTEN ARTICLE https://gorilla.bi/power-query/date-formatting/ Master Functions and Syntax in M https://powerquery.how ABOUT BI GORILLA BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #formatstring #date #bigorilla </video> <video> Easy Column Selection for Big Tables in Power Query M (Must Know Hack!) Description: Selecting columns in large tables can be frustrating, especially when you have to scroll endlessly or when you misclick after selecting many columns. In this video, I’ll show you a better way to select columns in Power Query M, making your work with big tables easier. I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:29 The issue 01:31 Storing Table Information 02:59 Picking a Category 03:21 Selecting Columns 04:18 Picking a Subcategory LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #ColumnSelection #powerquery #m </video> <video> The Definitive Guide to Power Query M - What to expect? Description: I'm happy to announce our new book: 'The Definitive Guide to Power Query (M). The book aims to teach users the M language, so they can solve almost 100% of their data transformation challenges. In this video, I walk through the table of contents and provide context on what the book teaches. You can buy the book here: https://geni.us/ODZl8 WRITTEN ARTICLE: https://gorilla.bi/power-query/the-definitive-guide-to-power-query-m/ ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #M #powerquery #bigorilla </video> <video> Formula Firewall: Referencing other Partitions in Power Query Description: Formula firewall errors are a common source of frustration. They appear when you violate its fundamental rules when combining data. There are two errors you may receive. In this video, you learn about the Formula Firewall error that appears when referencing another partition, while at the same time retrieving data from a source. You can buy the Definitive Guide to Power Query M here: https://geni.us/ODZl8 Master Functions and Syntax in M https://powerquery.how ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #firewall #powerquery #bigorilla </video> <video> Creating a 445 Calendar in Power Query M Description: Learn how to create a 445 calendar in Power Query M. This video covers setting up date columns, creating week, period, quarter and year indexes, and customizing for 445, 454, and 544 calendar variations. WRITTEN ARTICLE: https://gorilla.bi/power-query/445-calendar/ I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:33 Characteristics of 445 calendar 01:19 Fundamental Variables 01:49 Creating a Date Column 02:23 Starting Date of 445 Calendar 02:51 Creating Indexes 05:30 Flexible Period Index 10:55 Creating a Year / Quarter / Week column 12:33 Overview of important columns LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #445 #fiscalcalendar #powerquery #m </video> <video> Removing Milliseconds from a time value in Power Query M | 3 Methods Description: Time values in Power Query can have milliseconds up to the ten-millionths of a second. Unfortunately, this level of detail blows up the size of your data models. In this video, you learn three methods to remove the milliseconds portion of a time value. WRITTEN ARTICLE: https://gorilla.bi/power-query/remove-milliseconds-from-time-values/ I'm one of the authors of 'The Definitive Guide to Power Query M. If you want to improve your M language skills, you can get a copy here: https://geni.us/ODZl8 ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 TIMESTAMPS 00:00 Introduction 00:43 Displaying Milliseconds 02:25 Method 1: Formatting String 03:01 Method 2: Rounding 04:27 Method 3: Remainder LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #RemoveMilliseconds #time #m </video>

Contacts and Links

Description

Thanks for checking out BI Gorilla on YouTube!

My name is Rick de Groot and my goal is to help professionals like you advance your skills to the next level with Power BI. I look at issues users run into and provide them with ready to use solutions so you can shape your data and make accurate decisions.

👉 Join me by subscribing and participating in the comments with your questions or thoughts.

Visit my websites:
https://powerquery.how - to learn all about function syntax and examples
https://gorilla.bi - to get more in-depth articles and videos.

Keep crushing it — talk soon!

@Rickmaurinus

Videos from channel