Forum Discussion
Add Number to a Column
Hi Anonymous ,
I have a still confused about your requirement.
If I understand your scenario correctly that you want to create an index column in your table?
If you just create an index column for all of the rows for your table you could create the index column in Query Editor which Pauwnrajpp has mentioned.
If you want to create the index column based on the rank of the specific column, you need create a dax formula with Rankx function.
Please have a reference of this similar thread.
If you still need help, please share your data sample which could reproduce your scenario and your desired output.
Best Regards,
Cherry
Well its more complicated than that:
1º I Have in the data model a huge table with lets say 10 different questions and 1000 people answering that questions (from 1 point to 10) what means 10.000 rows for jsut only 10 questions
2º Then in the Data Viz frame where I am adding all the graphs and stuff like that I want a Table with those 10 questions and the average grade of the answers
3º I need an extra column ranking the Answers From the highest grade (number 1) to the lowest (number 10)
The problem is that this table is not in the Data Model is like Group BY table from the Data model and I cant get the proper solution to add this column
This will be the source table or the origin of the information
This one is the tabel that I want to show in the Data visualziation frame in wich I want the Average os the total responses for the questions
Thanks