Канал: BI Gorilla

Converting Unix Timestamp to DateTime Values in Power Query M #powerquery #m #unix

Converting Unix Timestamp to DateTime Values in Power Query M #powerquery #m #unix

Concatenate values in Power Query M | Avoid these pitfalls!

Concatenate values in Power Query M | Avoid these pitfalls!

Removing Milliseconds from a time value in Power Query M | 3 Methods

Removing Milliseconds from a time value in Power Query M | 3 Methods

Make your Group By Operations Dynamic in Power Query M

Make your Group By Operations Dynamic in Power Query M

Custom Comparer Function for Table.Group in Power Query M

Custom Comparer Function for Table.Group in Power Query M

Introducing Power Query How (Master the M language)

Introducing Power Query How (Master the M language)

Understanding Enumerations in Power Query M

Understanding Enumerations in Power Query M

Formula Firewall: Referencing other Partitions in Power Query

Formula Firewall: Referencing other Partitions in Power Query

Creating a SWITCH Function with Conditions in Power Query M

Creating a SWITCH Function with Conditions in Power Query M

Mimic a SWITCH function in Power Query using Record.FieldOrDefault

Mimic a SWITCH function in Power Query using Record.FieldOrDefault

Formatting Dates with Custom Format Strings in Power Query M

Formatting Dates with Custom Format Strings in Power Query M

Create a Join based on Date Range in Power Query

Create a Join based on Date Range in Power Query

The Definitive Guide to Power Query M - What to expect?

The Definitive Guide to Power Query M - What to expect?

Lookup Values in the Same Table with Power Query M

Lookup Values in the Same Table with Power Query M

Creating a Monthly Date Table in Power Query M

Creating a Monthly Date Table in Power Query M

Unpivot Columns And Keep Null Values in Power Query

Unpivot Columns And Keep Null Values in Power Query

Understanding List Sort in Power Query

Understanding List Sort in Power Query

Create a Running Total by Category in Power Query

Create a Running Total by Category in Power Query

Fast Running Totals in Power Query (Complete Guide)

Fast Running Totals in Power Query (Complete Guide)

The IN Operator in Power Query

The IN Operator in Power Query

Create Date Table with Dynamic Language in Power Query

Create Date Table with Dynamic Language in Power Query

Create Last Refresh Time that respects Daylight Saving in Power Query

Create Last Refresh Time that respects Daylight Saving in Power Query

Extract Dates From Text Strings in Power Query

Extract Dates From Text Strings in Power Query

Calculate Percentage of Total in Power Query

Calculate Percentage of Total in Power Query

Return Rows with Maximum Value in Power Query

Return Rows with Maximum Value in Power Query

Using the Text Format Function in Power Query

Using the Text Format Function in Power Query

Configuring Incremental Refresh in Power BI

Configuring Incremental Refresh in Power BI

Create Index Column By Group in Power Query

Create Index Column By Group in Power Query

Transform Column Names in Bulk in Power Query

Transform Column Names in Bulk in Power Query

Configure Drillthrough for Measures with USERELATIONSHIP by using Calculation Groups in Power BI

Configure Drillthrough for Measures with USERELATIONSHIP by using Calculation Groups in Power BI

The Secrets of Drillthrough in Power BI

The Secrets of Drillthrough in Power BI

List.Generate in Power Query - Tutorial with Easy Examples

List.Generate in Power Query - Tutorial with Easy Examples

Create Date Table or Calendar in Power Query M (Complete Guide)

Create Date Table or Calendar in Power Query M (Complete Guide)

How to Use List Generate to Make API calls in Power Query

How to Use List Generate to Make API calls in Power Query

4 Ways to Create Date Column for a Calendar in Power Query

4 Ways to Create Date Column for a Calendar in Power Query

Remove Leading Zeros from Text in Power Query

Remove Leading Zeros from Text in Power Query

Perform a Case Insensitive Replace Values in Power Query

Perform a Case Insensitive Replace Values in Power Query

Replace Values in Multiple Columns Based on Condition in Power Query

Replace Values in Multiple Columns Based on Condition in Power Query

Replace Values Based on Condition (in a Single Step) in Power Query

Replace Values Based on Condition (in a Single Step) in Power Query

Date calculations: find the first Monday of the Next Month in Power Query

Date calculations: find the first Monday of the Next Month in Power Query

Filter Column by List Items (Exact Match) in Power Query

Filter Column by List Items (Exact Match) in Power Query

Check if Column Contains Item from List in Power Query - Create Text.ContainsAny!

Check if Column Contains Item from List in Power Query - Create Text.ContainsAny!

Round Time to Nearest Interval (15 min / 30 min / hour ) in Power Query

Round Time to Nearest Interval (15 min / 30 min / hour ) in Power Query

Creating a Custom Filter Panel in Power BI

Creating a Custom Filter Panel in Power BI

Benchmarking with Row Level Security in Power BI

Benchmarking with Row Level Security in Power BI

Understanding CALCULATE in DAX: Percentage of Total

Understanding CALCULATE in DAX: Percentage of Total

Get nth value from comma separated list in Power Query

Get nth value from comma separated list in Power Query

Understanding CALCULATE in DAX: Filters

Understanding CALCULATE in DAX: Filters

Set Fixed Column Width in Matrix in Power BI

Set Fixed Column Width in Matrix in Power BI

Set Default Slicer Selection to Current Year or Month in Power BI

Set Default Slicer Selection to Current Year or Month in Power BI

When to use SUM and SUMX in DAX

When to use SUM and SUMX in DAX

The IN Operator in DAX | Combine multiple OR statements

The IN Operator in DAX | Combine multiple OR statements

Wat zijn de kosten van een Power BI project?

Wat zijn de kosten van een Power BI project?

Creating a Running Total in Power Query

Creating a Running Total in Power Query

Performing a full Anti Join in Power Query - Compare Two Tables

Performing a full Anti Join in Power Query - Compare Two Tables

Pivot Text Values in Power Query - Explained

Pivot Text Values in Power Query - Explained

Return Previous Row Value in Power query

Return Previous Row Value in Power query

Documenting and Structuring Queries in Power Query

Documenting and Structuring Queries in Power Query

5 ways to calculate last 12 months in DAX for Power BI

5 ways to calculate last 12 months in DAX for Power BI

Three Ways to add Leading Zeros to Numbers in Power Query

Three Ways to add Leading Zeros to Numbers in Power Query

Show last 13 Months from Slicer Selection in Power BI (DAX)

Show last 13 Months from Slicer Selection in Power BI (DAX)

How to create a journal entry with power query

How to create a journal entry with power query

How to Group By Maximum Value using Table.Max in Power Query

How to Group By Maximum Value using Table.Max in Power Query

Define Data Type in the Custom Column step in Power Query

Define Data Type in the Custom Column step in Power Query

Change Column Type By Position in Power Query

Change Column Type By Position in Power Query

This Excel Gorilla is going extinct..

This Excel Gorilla is going extinct..

Applying custom conditional formatting using a Measure in Power BI

Applying custom conditional formatting using a Measure in Power BI

Concatenate Text Values using Group by in Power Query (w/ Optional Delimiter)

Concatenate Text Values using Group by in Power Query (w/ Optional Delimiter)

Count the number of times a value appears in a column in Power Query

Count the number of times a value appears in a column in Power Query

Mastering the IF Function in Power Query - including Nested-IF statements (Complete Guide)

Mastering the IF Function in Power Query - including Nested-IF statements (Complete Guide)

2 Awesome Tips on How to Use the SWITCH Function in Excel

2 Awesome Tips on How to Use the SWITCH Function in Excel

3 Ways to SUM null values in Power Query

3 Ways to SUM null values in Power Query

How to Calculate Same Day Growth in Power BI (Episode 3/3)

How to Calculate Same Day Growth in Power BI (Episode 3/3)

How to Calculate Same Day Growth in Power BI (Episode 2/3)

How to Calculate Same Day Growth in Power BI (Episode 2/3)

How to Calculate Same Day Growth in Power BI (Episode 1/3)

How to Calculate Same Day Growth in Power BI (Episode 1/3)

How to Display Negative Numbers between Parentheses in Power BI

How to Display Negative Numbers between Parentheses in Power BI

Easy Grouping Or Binning with Power BI - No Code!

Easy Grouping Or Binning with Power BI - No Code!

Beginners Guide: How to Use the SUMPRODUCT Function

Beginners Guide: How to Use the SUMPRODUCT Function

Get Data From Web Using an Example Column in Power Query

Get Data From Web Using an Example Column in Power Query

2 Tricks to Create Unique Combinations From Multiple Columns – Power Query #7

2 Tricks to Create Unique Combinations From Multiple Columns – Power Query #7

How to Rank with Ties Using Group By in Power Query

How to Rank with Ties Using Group By in Power Query

How to Dynamically Rank with Ties in Power Query

How to Dynamically Rank with Ties in Power Query

Essentials for Creating a Calendar with Power Query

Essentials for Creating a Calendar with Power Query

How to Summarize Your Data Using Power Query - Part 1

How to Summarize Your Data Using Power Query - Part 1