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 function
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.
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.
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.