cancel
Showing results for
Did you mean:
Helper III

## Ordering columns with same description

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 ?

1 ACCEPTED SOLUTION
Community Support

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.

3 REPLIES 3
Community Support

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.

Super User IV

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

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Memorable Member

Create a measure like below:

``Measure 5 = MIN(your_table[id])``

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

Aiolos Zhao

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

#### Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

#### Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors