Tag: DAX

Get Answers from Reports Faster with SVG
Get Answers from Reports Faster with SVG
Webinars

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

INTRODUCING DAX WINDOW FUNCTIONS (PART 2)
INTRODUCING DAX WINDOW FUNCTIONS (PART 2)
Blog Posts

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

INTRODUCING DAX WINDOW FUNCTIONS (PART 1)
INTRODUCING DAX WINDOW FUNCTIONS (PART 1)
Blog Posts

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

DAX : Count number of last known state
DAX : Count number of last known state
Blog Posts

Using DAX to help group and count the last known state I got asked recently to help with a DAX measure for an interesting problem in the inventory domain. The requirement is to generate a chart showing the count of the last known State of a given number of items. Here is a walkthrough of… READ MORE