From the course: Power BI Weekly

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Using INDEX to access a value position

Using INDEX to access a value position - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Using INDEX to access a value position

“

- [Instructor] If we have a list of items or values in a field within Power BI, one way we can access a position in this list is through the index function. DAX and Excel functions use an index of one as the starting value for the positions to access items in the list. This contrasts to most programming languages, which use an index of zero. Let's say we're working with several months of interest rates in Power BI Desktop. If we want to access the date of the first week, let's use the index function to do so by creating a new measure. We'll put a one in the first parameter of the index function because we're accessing the first item. We'll then skip over the second parameter because we don't need it for this formula to work by putting in two consecutive commas after the one in the first parameter. Next, we need to determine the field that we're accessing the index of by ordering it with the ORDER BY DAX function nested…

Contents