How can I change the sorting of a table column to another column?

[ManoBrasa]

Hi!

I created a new summarized table with the bellow structure:

Date	Desc	SprintId	Points	Index
25/10/22 00:00	Resolved	156587	0	2256
25/10/22 00:00	Resolved	638	0	2205
25/10/22 00:00	Resolved	741	0	2206
25/10/22 00:00	Resolved	809	0	2207
25/10/22 00:00	Resolved	1591	0	2214
25/10/22 00:00	Resolved	2094	0	2215
25/10/22 00:00	Resolved	3239	0	2216
25/10/22 00:00	Resolved	3914	0	2217
25/10/22 00:00	Resolved	156418	0	2255
23/11/22 00:00	Resolved	159768	0	2488
18/05/22 00:00	Resolved	156418	0	1094
22/02/22 00:00	Resolved	127928	0	590
22/02/22 00:00	Resolved	127929	0	591
11/08/22 00:00	Resolved	128523	0	1658

Desc (Description) - Resolved/Entered Issue/Scope Changed
Points - Is the story points from the Issue.

Table is sorted by Desc column and I want to sort by date. I try to use an index column to change the ordering but they duplicate some numbers in different rows.

How can I change the sorting of Desc column to one of date column or index column?

Index = RANKX('Burndow Summarized', RANKX('Burndow Summarized','Burndow Summarized'[Date],,ASC,Dense)+0.01*RANKX('Burndow Summarized','Burndow Summarized'[SprintId],,ASC,Dense)+0.02*RANKX('Burndow Summarized','Burndow Summarized'[Desc],,ASC,Dense)+0.03,,ASC,Dense)

My ultimate goal is to create accumulative measure for a burndown chart for each sprint.

[iceparrot]

Hey @ManoBrasa, 

you can open the  Data view  in Power BI Desktop an select the table you want to sort.  

Then klick on the column you want the table to be sorted accordingly and then open the Column Tools in the top navigation and select Sort by column. 

Then you can select the column you'd like to sort the table:

Please let me know if this solves your problem.

[VahidDM]

Hi @ManoBrasa 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/