Forum Discussion
Sort by Index
Hello,i have data with three Columns: "Index, Column Name and Value" and repeated data in Columns: Column Name and Value. and need to display data in table with columns "Column Name and Value o...
Anonymous Index should be unique for each unique 'Column name'. As an option you can create additional index column with min index value for each value of 'column name':
add_index_column=var current_name='table'[Column Name]
return MINX(FILTER(ALL('Table'),'Table'[Column Name]=current_name),'Table'[Index])