I was recently reading an interesting question by a user. Given a date/time value and a number of hours, add the number of hours to the date, but considering some constraints related to working hours: The working hours are 09:00-17:00…  Read more

The introduction of the weak relationships in Power BI composite models enables new data modeling techniques. However, not all of the many-to-many relationships can be managed by using weak relationship. The “classical” many-to-many relationships in data warehouse is a design…  Watch now

Relationships are the foundation of any Power BI or Analysis Services Tabular data model with multiple entities. At first sight, this is a trivial concept, especially if one has a knowledge of relational data modeling. However, the ability to create…  Watch now

This article describes how to display the filter context applied to a calculation using a special DAX measure in Power BI Tooltips.  Read more

This article describes how to write DAX measures that compute aggregations or comparisons with past dates without showing or comparing future dates.  Read more

This week OKViz released Smart Filter Pro 2.0.5, which is the first commercial version of a custom visual for Power BI produced by OKViz. This is the first of other rich and advanced visuals that will be released in the…  Read more

This article describes the real meaning of and the required action for a few common error messages that can appear when users define DAX expressions in Power BI.  Read more

We are approaching the end of 2018, so it is a good time to review what happened in the DAX world this year, what we’ve been up to at SQLBI and what is going to happen in 2019. New DAX…  Read more

Today I woke up with an interesting question, about how to show a selection of months in a nice way, detecting contiguous selection. You can easily understand the desired solution from the following figure: I enjoyed writing a quick solution,…  Read more

Activating bidirectional cross-filter in a Tabular data model might create ambiguous paths in the chain of relationships, resulting in very dangerous models as numbers become unpredictable. This article provides a deep explanation of the kind of ambiguity that might appear…  Read more