Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
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!
Solved! Go to Solution.
Hi, let me propose a solution to this:
Step1:
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]))
Step 2:
Change the Data Type to Month-year-alt to Date
Step 3:
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
Ready
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.
Thanks!
Thank you!
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?
Great thanks!
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:
http://community.powerbi.com/t5/Desktop/Custom-Sorting-in-PowerBI/td-p/126534
but I just could not figure out how to get the numbers in the ID column in the newly created table shown below.
Thank you!
Hi, let me propose a solution to this:
Step1:
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]))
Step 2:
Change the Data Type to Month-year-alt to Date
Step 3:
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
Ready
It works! Great thanks to you!!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |