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 Power BI/M/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 Power BI/Intermediate/M/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
