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

Optimizing HR Head Count DAX Measure with Power BI

The head count for human resources is a rather common request found in Power BI related forums and the usual suggestion is to implement the Events in progress DAX Pattern from SQLBI. I built a sample model to experiment with this pattern.More