I wanted to sort data by customized date, so I created a table as below. Then I couldn't figure out how to add a column showing the row number of each. Does someone know about that?
I appreciate your help!
Go to Solution.
Hi, let me propose a solution to this:
Create a Table with 2 Columns instead of your Month-year Table
MonthYearTable = DISTINCT(SELECTCOLUMNS(Table1,"Month-year",Table1[Month-Year],"Month-year-alt",Table1[Month-Year]))
Change the Data Type to Month-year-alt to Date
Create a New Calculated Column:
MonthSort = RANKX(MonthYearTable,MonthYearTable[Month-year-alt],,ASC)
Step 4: Select your first Column: Month-year and go to Modeling-Sort by Column and choose MonthSort
Proud to be a Datanaut!
View solution in original post
Just add an index column
Thank you so much for your reply.
Could you show me where I can add it? I tried to add an index column under Modeling, but it didn't work; I also tried to edit queries, but the new table I created did not show in the list of tables.
I found the index column in query editor, but the problem is, the table I created did not show up, so I was not able to edit queries.
Do you know how to solve this problem?
What other columns do you have in Single Select.
There are a bunch of columns in this table, some are texts, some are numbers. Basically, I created a new table under the Data view - Modeling, and used one of the variables (Month/Year) in the single-select table.
What I want to do is similar to this question:
but I just could not figure out how to get the numbers in the ID column in the newly created table shown below.
It works! Great thanks to you!!
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!