September 2019 - Hat Full of Data

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

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.

Flow/Power Query

9th September 2019

AI Builder with Flow and Power Apps – Building the Model

In this post I will document how to build an AI Builder object detect model. We will create the list of items to detect, upload images, identify each image and then train the model.

AI Builder/Flow/How to/PowerApps

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.