M Archives - Hat Full of Data

8th June 2021

Power Query – Get Previous Row Data

In this post I will describe how to get previous row data that matches a criteria. This post will demo getting a person’s previous score.

M/Power Query

4th May 2021

Power Query – Dynamic Data Source and Web.Contents()

This is the first post in a series to create a Star Wars report. This post handles the issue of using a parameter as the url in a web Power Query. This type of data source is referred to as a Dynamic Data Source. It will not refresh in the Power BI service unless you do some tricks. Fetching Data...

M/Power BI/Power Query

15th April 2020

Power Query – Replace values for whole table

Today’s challenge was to replace the values on all the columns in the query when I know the columns will change so I don’t want to name them.

M/Power BI/Power Query

6th October 2019

Power Query – Function to Execute an SQL Procedure

This is the fourth post in my series regarding writing custom functions in Power Query. This post describes how to create a function that will execute an SQL procedure, passing in a parameter. Stored Procedure My database contains a very simple procedure that given a cost center returns all the expense records. It can be run with the following SQL...

M/Power BI/Power Query

5th October 2019

Power Query – Building functions to fetch web data

Often web based data is split across multiple pages. This post describes how to use a function to fetch web data from multiple pages by using parameters.

M/Power BI/Power Query

29th September 2019

Power Query – Multi-step Function

This post describes how to build a multiple step function in M using a parameter and using create function to build the function code.

M/Power BI/Power Query

27th September 2019

Power Query – Custom Handwritten Function

In this post I will write a simple custom handwritten function to perform a calculation, which can then be used in your queries.

Intermediate/M/Power BI/Power Query

Category: M

Power Query – Get Previous Row Data

Power Query – Dynamic Data Source and Web.Contents()

Power Query – Replace values for whole table

Power Query – Function to Execute an SQL Procedure

Power Query – Building functions to fetch web data

Power Query – Multi-step Function

Power Query – Custom Handwritten Function