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
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
