The introduction of the DAX query view (official blogpost) and the new INFO DAX functions (official blogpost) gives us some very possibilities to update our measures without using the formula bar. We can for instance create a query that shows all the measures that has an error message like this This will extract all my… READ MORE
Get Answers from Reports Faster with SVG SVGs have been around for a very long time. However, their use in Power BI was minimal for a long time. However, their use is gradually being unlocked, and they can still be used in more and more places. We can even use them within the visuals to… READ MORE
This is the second installment in our two-part series on DAX window functions announced in the December 2022 release of Power BI Desktop. I will first answer the questions that I had received from the community about topics covered in the first article, and then go into more technical details about the implementations of these functions to… READ MORE
The December 2022 release of Power BI Desktop includes three new DAX functions: OFFSET, INDEX, and WINDOW. They are collectively called window functions because they are closely related to SQL window functions, a powerful feature of the SQL language that allows users to perform calculations on a set of rows that are related to the current row. Because these functions… READ MORE
