Intermediate Archives - Hat Full of Data

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

25th July 2019

Power BI – Using inactive relationships in a measure.

In this post I will show a simple example of how to use a different relationship between two tables in a measure. The example I will use is a list of tasks with start and finish dates. The request is for how many tasks start per week and how many finish per week to be plotted on a column chart.

Intermediate/Power BI