1077 results
  • 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

  • SqlBits 2024 Unveiled

    If there is a conference you should attend at least once, it is SqlBits. Why? Because it is magic. It is impossible to imagine organizing such an international event with a team of volunteers. It is against common sense actually…  Read more

  • This article describes how to read the active security roles in a Tabular model for Power BI or Analysis Services. This way, you can use measures and calculation groups to customize a report based dynamically on security roles active for…  Read more

  • This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the latest version of the template in the Dax Date Template page.  Read more

  • Handling BLANK in DAX

    The blank value in DAX is a special value requiring particular attention in comparisons. It is not like the special null value in SQL, and it could appear in any conversion from a table expression. This article explores in details…  Read more

  • This month we published a second draft of the Window functions in DAX whitepaper for the SQLBI+ subscribers. After the first draft we published in January 2023, we added new sections and updated others. We completely rewrote the “apply semantics”…  Read more

Show more