Recursive Functions in Power Query We are all more or less familiar about recursive functions with programming languages such as Python, but what about Power Query? Can we use recursive functions with it? The answer
Tag Archives: excel
Slow Changing Dimensions Imagine you have a simple data model like the one below composed of four tables. One fact table ( Sales ) and three dimension tables (Customers, Products, Dates). If you wanted to
Generating Combinations in Power Query In this post I wanted to share the function I have created to generate combinations in Power Query. The function will accept two parameters. The first parameter is a list
Power Query – Add blank row at each change in value This is a follow-up post to a question asked on Mr Excel forum. The OP wanted to use Power Query to add an empty
Histogram with Power Query With the help of custom M coding, it is possible to create a frequency distribution by using power query. This is one area where Power Pivot would shine against Power Query
Creating a 4-4-5 Calendar with Power Query 4-4-5 calendar is a common calendar structure for some industries such as retail and manufacturing. You will need to create such a calendar if you wish to harness
Power Query: Sort a Column by Another Column This is a follow-up post regarding a solution I provided on this post on Mr.Excel forum. The OP had a table in Power Query where one of
Create a Fixed Length CSV with Power Query The Power Query Combiner Functions can make your life very easy when it comes to turn a table into a fixed length CSV file. The ones I
Concatenate Table Headers with First Row in Power Query Concatenate Table Headers with First Row in Power Query Today I found myself in the situation of dealing with a table like the one below, where
Replicate SUMPRODUCT in Power Query Today I stumbled upon the M function List.Zip which I thought would provide a valid alternative to my previous post about replicating SUMPRODUCT in Power Query. According to Microsoft Power