-
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
-
This article describes all the options and APIs available to improve the use of SQLBI video courses in an enterprise environment. Read more
-
This article describes the best practices for deciding when to use (and when not to use) KEEPFILTERS in CALCULATE filter arguments. Read more
-
We are proud to announce the availability of our new book, Optimizing DAX. Read more
-
This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event. Read more
-
Digital media content creators have an ethical responsibility to journalistic integrity. All of them do; all of us… including myself. Read more
-
Almost a year ago, we announced the release of three sections (core concepts, formula engine, and VertiPaq); in November 2023, we released the DirectQuery over SQL section; now, in April 2024, we release the last section of Optimizing DAX about… Read more
-
Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. Read more
-
What is the right choice between Direct Lake and Import mode in Power BI? Read more
-
This article describes how you can use a scatterplot visual to make more effective Power BI reports. Read more