power query

I'm trying to invoke a function that sorts a column in the calling query's table. I'm basically trying to turn this... ...into this... I made this simple function: = () = let Source = ...

I have the following data in PowerQuery: | ParentX | A | | ParentY | A | | ParentZ | A | | ParentY | B | | ParentZ | B | | ParentX | C | | ParentY | C | | ParentZ | C | I want to add an index col...

Recently I shared a Matrix Multiplication Power Query technique here, and explained how to use List.Generate as the core step of the multiplication. It was fun to experiment with List.Generate and use it to implement a kind of a For-Loop. So I thought it would be cool to use List.Generate to iterate over a nested loop. Below …

There are plenty examples on how to unpivot nested tables. But what if a table we need to make flat has no nested headers for repeating groups of columns?

Learn about the mathematical formulas available in the Power BI Desktop and Power Query as well as how to load and convert data for your reporting needs.

Power-BI-Desktop-Query-Extensions - Various M Queries that you can use to make life easy-peasy

Whenever I’m faced with a data mashup problem in Power BI, I try to check if it can be resolved with a standard M functions exposed by the intrinsic variable #shared. Navigating this data str…

For this post, I’m show how we can Keep Only Numbers from a string of text (removing all other characters), as well as keep only text (removing all numbers)

The Add Column By Example functionality that appeared in the April 2017 release of Power BI Desktop is, I have to say, very cool: I’ve used it quite a bit in the last few weeks and it really does w…

Below is where I had a situation where I wanted to put in a parameter within a piece of text. This was so that I could then dynamically change the Month Version for my budget and when I refreshed m…

Developing queries for Power BI and Power Query I had to look into documentation or check my previous solutions from time to time in order to get answers to same questions again and again. So, I en…

There are abundant public data sources on the Web, and it is so tempting to import and mash them up with your existing data sets in Power BI and Excel Power Query to gain new correlations and insights. While it’s easy to import static tables from many websites in Power BI and Excel Power Query, you’ve probably …

Very often I have thought about trying M instead of R for machine learning problems in PowerBI. Not only because I’m such a big fan of M, but also because (…) Read more

The R ways in #PowerQuery. How R.Execute() can be used for other non-statistical related tasks #PowerBI

Get your own Power Query editor with intellisense, snythax highlighting, parameter hints and help texts. Custom M code has never been easier to write.

I saw a blog post recently where Jay Killeen was talking about how he handles his Source Control for the Query Editor or Power Query. And this got me thinking of how I could automate this in a quic…

Sometimes (dare I say often, or even usually) the data you have available is not in the ideal shape for analysis in Power BI. These problems can manifest i

Here comes some long awaited comfort functions for part 2 of my easy P&L series, where you don't have to define the single accounts any more.

Today I discovered that we can use conditions in many of the N-selecting functions where one/I would normally expect just a number-expression for the N: Table.RemoveFirstN( table as table, optional countOrCondition as any) (…) Read more

The other day when I was thinking about Power Query functions (as you do) it occurred to me that they would be a lot more usable if, when you invoked them, you could show your users a dropdown box …

Things to keep in mind when implementing time-delayed evaluations in #PowerBI #PowerQuery

Follow Me Order is a crucial force in life, especially if you are a data analyst. But as we will see today, the misuse of order might cause an unexpected chaos. In today’s post, we will discuss the chaotic nature of column ordering in the Query Editor of Power BI and Power Query / Get & …

In a previous blog post, I explained how to list all the Data Platform MVP by parsing a single web page. In a second blog post, I parsed the individual pages of each MVP to get information about he…

In a first blog post, I explained how to list all the Data Platform MVP by parsing a single web page. In a second blog post, I parsed the individual pages of each MVP to get information about her a…