Category: 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.

Categories 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.

Categories Intermediate/M/Power BI/Power Query

23rd September 2019

Power Query in Flow – Summarising the Data

In this post I will look at the different options we have for summarising the data using grouping and pivoting with Power Query.

Categories Flow/Power Query

6th September 2019

Power Query in Microsoft Flow – Joining Tables

In this post I will introduce one of the most powerful parts of Power Query, joining tables. Its the vlookup part of Power Query.

Categories Flow/Power Query

26th August 2019

Power Query in Microsoft Flow – An Introduction

This is the first post in a new series regarding Power Query in Flow. In this post I will cover the basics of connecting to SQL Server, filtering and sorting the data and finally adding calculated columns.

Categories Flow/Power Query