From the course: Power BI Weekly

Unlock this course with a free trial

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

Utilizing ROWNUMBER DAX function

Utilizing ROWNUMBER DAX function - Power BI Tutorial

From the course: Power BI Weekly

Start my 1-month free trial Buy for my team

Utilizing ROWNUMBER DAX function

“

- [Person] In Power BI, one of my favorite approaches is creating a separate report page as a drill-through to get more detailed data in a table visual, for example. One challenge with this table visual, though, is that there isn't an index automatically added to it like we see in programming data-frame objects or even the row numbers displayed on the left side of an Excel sheet. However, we can create a one-base index to add to our table by creating a DAX measure. To display these row numbers, we can create DAX measures to do this that will dynamically reflect the row number for each row in the table. We can build these index row numbers using DAX functions like "ROWNUMBER" and "ORDERBY." In Power BI Desktop, I already created a table visual for the electricity generation by hour using the date/time field with columns for the generated electricity by individual energy source. There are quite a few rows in this table, but…

Contents