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