October 2019 - Hat Full of Data

26th October 2019

PowerApps – Function Component

In this post I write a simple function component that takes one value and returns a calculated value. This creates a resusable function like feature.

Components/How to/PowerApps/SVG

25th October 2019

PowerApps – SVG Introduction

In this SVG Introduction post we will cover adding a simple SVG drawing to a PowerApp screen. Future posts will show how to manipulate that image.

PowerApps/SVG

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

Monthly Archive: October, 2019

PowerApps – Function Component

PowerApps – SVG Introduction

Power Query – Function to Execute an SQL Procedure

Power Query – Building functions to fetch web data