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
Ambiguous model and USERELATIONSHIP
When USERELATIONSHIP activates a relationship that makes a model ambiguos, the effect is to deactivate the other previously active relationshipMore
Adding a Static Table with Types in Power Query With M Language
M language function #table() can be used to create static table in a code readable way and also to specify column typesMore
Circular Dependency in DAX caused by CALENDARAUTO
CALENDARAUTO generated Date table can cause circular dependencies when calculated tables are added to the modelMore
How To Set Up Power BI New Composite Models
Composite model is a powerful new feature enabling to add a local model with new data to be used with an existing remote model.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
Sergio Murru 