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

Variables in DAX and Common Mistakes

This post purpose is to show two common mistakes that happen when using DAX variables. Variables in DAX are a powerful tool that improves the readability of DAX code. But their name is misleading, since DAX variables behave like constants. The syntax to define a DAX variable is straightforward: For instance, this is valid DAX…More