In this post I show a script to automatically generate a basic parent-child hierarchy as described in the parent-child hierarchies DAX pattern
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 posts
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…
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.
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)
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.
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.
When USERELATIONSHIP activates a relationship that makes a model ambiguos, the effect is to deactivate the other previously active relationship
M language function #table() can be used to create static table in a code readable way and also to specify column types
CALENDARAUTO generated Date table can cause circular dependencies when calculated tables are added to the model