Ordering columns with same description

[MiguelSaldana77]

Hi,  I have a problem ordering a column,  because son elements have different Ids,  This is an example

Column	id
A	1
A	2
A	1
B	3
C	4
D	5
E	6
E	7

I expect this Order

Column	id
A	1
B	3
C	4
D	5
E	6

How could  do This ?

[v-easonf-msft · Accepted solution]

Hi , @MiguelSaldana77 

You can  try to create a calculate table as below:

Soultion1 = SUMMARIZE('Table','Table'[Column ],"Id",MIN('Table'[id]))

You also can create a calculate column :

Soultion2 = CALCULATE(MIN('Table'[id]),FILTER('Table','Table'[Column ]=EARLIER('Table'[Column ])))

Here is a sample .

pbix attached

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@MiguelSaldana77 , In case you are looking for a new column as a sort column

sort column = minx(filter(Table,[Column] =earlier([Column])),[id])

[AiolosZhao]

Hi @MiguelSaldana77 ,

Create a measure like below:

Measure 5 = MIN(your_table[id])

Then put the "column" and Measure in the table.

Please try.

Aiolos Zhao