I wrote an article about Time Intelligence in Power BI Desktop to explain how to fix measures using DAX functions for time intelligence when you have a data model where the relationship uses surrogate keys. THe short description is that all the time intelligence  Read more

If you are using Power BI Desktop or Power Pivot in Excel 2016, you should learn when and how you can use GROUPBY instead of SUMMARIZE. The SUMMARIZE function is very powerful and internally very complex, so it’s easy to find scenarios where you get unexpected  Read more

In a couple of weeks, I will move to Australia for 3 weeks, visiting Melbourne and Sydney for a number of events and training. This is the list of topics in public events you can attend (with link to registration pages – remember that SQL Saturday conferences  Read more

I recently wrote an article about how to Create Static Tables in DAX Using the DATATABLE Function . Such a new DAX feature (the DATATABLE function) will be likely used in the upcoming Analysis Services Tabular 2016, but it is not used neither in Power  Read more

Last week Amir Netz presented in the Power BI blog a detailed introduction to the Synoptic Panel written by Daniele Perilli. This component won Power BI best visual contest in October, but since then we received many feedback and Daniele worked on it  Read more

I don’t usually blog about news, unless there is a relevant impact on future directions. Last week we have seen a huge number of announcements for Power BI ( Custom Visuals now available to anyone through a gallery online, you can import them in also  Read more

Last week we launched a new page in SQLBI website: DAX Puzzle (you can also use www.daxpuzzle.com ). The idea is very simple: we describe a scenario, we ask to solve a problem in that scenario and we might provide some hint to help you finding the solution.  Read more

I am so happy to announce that The Definitive Guide to DAX is finally available! I and Alberto Ferrari spent one year writing this book, and several years collecting the knowledge necessary to do that. The complete title is The Definitive Guide to DAX:  Read more

Today (September 30, 2015) is the last day to submit an entry in the Power BI Best Visual contest . I and Daniele Perilli (who has the skills to design and implement UI) spent hours thinking about something that would have been challenging and useful  Read more

Almost 3 years ago I wrote an article with the rules for DAX code formatting . If you quickly look at the article, you might think that it is all about readability of the code, and this is fundamentally true. But there two rules that have a particular  Read more