A simple implementation of matrix multiplication in DAX just for fun.More

## Deterministic Random Datasets with Power Query

In this post I’m showing how to create random data with Power Query that doesn’t change when a refresh operation happens using the List.Random() M functionMore

## Loading Large Random Datasets with Power Query

In this article I show a technique to build large random datasets using Power Query and M functions without the need of an external data source.More

## Local Functions in Advanced Scripting with Tabular Editor

Local Functions, provided by C# 7 and following versions, can be used inside Tabular Editor Advanced Scripting. They help to reduce duplicates and therefore to write better, more readable code.More

## Parent-Child Hierarchy Scripting with Tabular Editor

In this post I show a script to automatically generate a basic parent-child hierarchy as described in the parent-child hierarchies DAX patternMore

## Script To Generate Trending Measures With Tabular Editor

Tabular Editor Advanced Scripting is a powerful features that can be used to automate the generation of groups of measures. In this post I show how I implemented a script to automatically generate the Trend measures described in my last two postsMore

## Simple Linear Regression in DAX with Calculation Groups

In the previous post I showed a simple Linear Regression measure that works on a four level Hierarchy: Year-Quarter-Month-Day. The code is rather long, and implementing the Linear Regression formula for several measures would require a lot of copy & paste. Luckily there is a better alternative to copying and pasting code: that is to…More

## Simple Linear Regression in DAX with Hierarchy on Date Table

Trend lines cannot be used when the X axis is not numeric. Simple Linear Regression can be implemented in DAX to overcome this limitation. Some care must be taken when hierarchies are used.More

## Duration Formatting in Power BI with Calculation Groups

Calculation Groups can be used to implement custom formatting of measures. In this post I implement a CG to format a duration as DDD:HH:MM:SS (days, hours, minutes and seconds)More

## Loading 1.6 Billion Rows Snapshot Table with Power Query

In this article I show a Power Query implementation of the snapshot table for the HR head count sample model. Then I load 1.6 billion rows snapshot table for a larger model.More