Forum Discussion
Charline_74
Resolver I
Resolver IHaving an index column in a visual table
Hi On my Power BI report, I have a visual table that fetches columns from several tables. And I'd like to create an index in this visual but I don't know how to do it? Does anyone have a solution?...
Charline_74 , You can create a column or measure using RANKX function
For calculated column
Index = RANKX(ALL('Sales'), 'Sales'[OrderDate], , ASC, DENSE)
For measure
IndexMeasure =
VAR CurrentRow = MAX('Sales'[OrderDate])
RETURN
RANKX(ALL('Sales'), 'Sales'[OrderDate], CurrentRow, ASC, DENSE)
Charline_74Resolver I
Resolver Ibhanu_gautam & manvishah17
how do I do this when none of my columns contains unique data?
Here's the result I got :
- bhanu_gautam
Super User
You can merge two column using concat and create some unique values if possible in your table
- Charline_74
bhanu_gautam : I don't have that option