Multiple replacements or translations in Power BI and Power Query – The BIccountant
This article shows how to perform multiple replacements of text at once. This version is very fast. You will also learn some cool tricks in the M language.
Multiselect, Filtering And Functions In Power Query – Chris Webb's BI Blog
If you’re a Power Query enthusiast you’re probably already comfortable with creating functions and passing values to them. However in some scenarios you don’t want to pass just a single value to a …
Multiple Replacements of words in Power Query – Ivan Bond's blog
Post of Chris Webb inspired me on creation of alternative way to make replacement in table column using separate table with list of Old & New values. Say, more scalable solution. Because List.G…
Using List.Generate() To Make Multiple Replacements Of Words In Text In Power Query – Chris Webb's BI Blog
Recently I had a request for help from someone who wanted to do the following in Power Query: take a piece of text and then, using a table, search for all of the occurrences of the words in one col…
Extract Data from a Mixed Column - The Ken Puls (Excelguru) BlogThe Ken Puls (Excelguru) Blog
More and more I’m seeing examples where people are trying to extract data from a mixed column. In other words, they have two data types in a single column, but need to find a way to extract one from the … Continue reading →
Sharing Power Query Queries With Azure Data Catalog – Chris Webb's BI Blog
About a week ago, without any warning, a much-awaited new feature lit up in Azure Data Catalog: the ability to share Power Query queries between workbooks and users. In fact it’s not really a new f…
Referenced Queries And Caching In Power BI And Power Query – Chris Webb's BI Blog
Last week, Maxim Zelensky (whose blog is well worth checking out) tweeted about a very interesting answer he had received to a question he posted on the Power Query MSDN forum, on the subject of ca…
Speed up the PowerBI and Power Query design process
You can avoid long waiting time in your design process which is caused by data loading in the background by using filters. Centrally toggled will they speed
Add actions to an existing query or function in Power Query
Use a parameter for a field name
Creating a Function error
Share and Refresh Power Query with Local Links - PowerPivotPro
By Matt Allington The concept of parameter tables in Power Query will be familiar to some and new to others. A parameter table is a way that you can “pass
Writing Custom Functions in Power Query M | RADACAD
Dynamic Column Selection In Custom Columns In Power BI/Power Query/M
When you’re writing an M expression for a custom column in Power BI or Power Query it’s easy to reference the values in other columns. A slightly more difficult question, however, is how can you re…
Using The Invoke Custom Function Button In Power BI – Chris Webb's BI Blog
There are a lot of cool new features in the September 2016 update for Power BI, so many in fact that several of the really important changes in the Query Editor are in danger of going unnoticed. In…
Mike Carlo
PowerQuery Dynamic Date Dimension Table Filtering
in Power BI Desktop , PowerQuery Excel
Web.Contents(), M Functions And Dataset Refresh Errors In Power BI – Chris Webb's BI Blog
One slightly frustrating feature of Power BI is that some of the cool stuff you can do in M code for loading data, and which works in Power BI Desktop (and in Power Query), causes errors when you t…
Part 2: Combination of rows of tables list in Power Query
Part 1 describes approach showing how to work with List.Generate, Table.FromRecords, List CrossJoin in Get & Transform (aka Power Query, M language). Homework is done. Advice is digested. And I…
Combination of rows of tables list in Power Query
Recently I faced interesting Power Query problem. Actually, initial problem has nothing related to Power Query. I required to export quite big volume of data from SAP BW using Business Objects Anal…
Unfold Child-Parent hierarchy in Power Query
In this post I consider two types of hierarchies First table defines typical hierarchy of companies. Usually, such hierarchy is used for financial reports to group key figures. Most probably, we kn…
Data-Driven Power BI Desktop Parameters Using List Queries – Chris Webb's BI Blog
The July 2016 update for Power BI Desktop included the ability to make parameters data-driven, by giving the option to bind the Suggested Values (previously called the Allowed Values) property of a…
Quick Filter for Unique Values in Power Query and Power BI | Excel Inside
There are many ways to get a value from parameters table and then pass it to query. One of this methods uses direct selection (quick filter) of unique parameter name.
Displaying Help For A Power Query Function
Matt Masson and Theresa Palmer gave an excellent presentation on Power Query and M for the PASS DW/BI Virtual Chapter a few days ago (hopefully it will be on their YouTube channel soon). One thing …
Comparing Columns In Power Query
A few weeks ago I wrote a post about comparing the contents of entire tables in Power Query, and a question came up in the comments about how you might go about comparing values in columns rather t…
Building Relative Date Reports in PowerPivot
It’s a very common requirement when you’re building a report in PowerPivot (or indeed in any BI tool) for it to automatically show data for today’s date, the current week or month (plus maybe a set…
Specifying Allowed Values, Sample Values and Descriptions For Function Parameters In Power Query–Part 2 – Chris Webb's BI Blog
power
Power Query And Function Parameters Of Type List
Here
Building A Reporting Solution Using Power Query with Chris Webb
SQLBits Session - See how to use Power Query to build a detail-level reporting solution with Chris Webb
Power Query: Allowed values
How slow is a bit slow? How many rows are there in each table, and what type of data source are you using? I was wondering if a more 'relational' appr