1065 results
  • These are pivotal times with the large adoption of new technologies like generative AI systems that will certainly impact how we work, along with a lot of other things. If you look at how Alberto and I answer questions related…  Read more

  • We recently released the second edition of the Optimizing DAX video course. Despite its volume, some details always did not find space in the training material. The REDUCED BY syntax of xmSQL is one of those details.  Read more

  • At the end of March, we released the second update of SQLBI+ with a new session about different types of many-to-many relationships in DAX. The goal is to explain the difference between the many-to-many cardinality relationship available in Power BI…  Read more

  • This article describes how to optimize a text search operation in DAX. This technique can improve the performance of Power BI reports that use the contains condition in the filter pane or the filter mode of the Smart Filter Pro…  Read more

  • This article describes the possible rounding differences that can appear in DAX. They are related to the data types and the operation being performed: knowing these details helps you write more robust DAX formulas and avoid errors in comparisons.  Read more

  • Yesterday we published an April Fool: Navigating the Data Ecosystem: A Revolutionary Analytics Architecture. The idea of writing a piece about a new architecture that could immediately make the latest cool buzzwords obsolete rounded my mind for a few weeks.…  Read more

Show more