-
I am proud to announce the second version of the Contoso Data Generator! In January 2022, we released the first version of an open-source project to create a sample relational database for semantic models in Power BI and Analysis Services.… Read more
-
Did you ever want to extract a VPAX file using a command line tool? If you are among the early adopters of DataOps principles or simply want to automate processes, you will be glad to know that we now have… Read more
-
This article clarifies how DAX evaluates variables, which is important to avoid common mistakes when using DAX for the first time. Read more
-
We recently surpassed the 100,000 subscribers milestone on the SQLBI YouTube channel. Therefore, Alberto and I unboxed the plaque received by YouTube. We are still fighting for who should keep it! Thank you all for watching us. Read more
-
This article introduces the ‘atomic design methodology’ as an approach to make Power BI development more efficient and repeatable. Read more
-
This article describes the DAX filter context using a conceptual model based on a visual representation. Read more
-
In 2023, we released the first draft of the Window functions in DAX whitepaper as part of SQLBI+. Since then, we have released a few updates and are now glad to announce the availability of the related 3-hour video course… Read more
-
This article describes a simple approach that you can apply to improve your reports and dashboards. Read more
-
DAX is not like M when it comes to data manipulation, and it is not supposed to do that. However, if you need something in DAX similar to Table.FromList in M, this blog post is for you. If you have… Read more
-
I am glad to be back in Australia in August 2024: we planned three Mastering DAX classes and two SQLBI Days about DAX Optimization. Read more