cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Group by most recent date, then next most recent, etc

Hello! I'm trying to convert a set of disparate dates into numbers (or indicators - text is fine) indicating the most recent in a group, next most recent in a group, etc. For instance:

turn this:

 Store Date A 9/1/2019 A 5/1/2019 A 3/1/2019 A 1/1/2019 B 8/1/2019 B 7/15/2019 B 6/3/2019 B 4/1/2019 C 7/16/2019 C 6/1/2019 C 5/1/2019 C 4/1/2019 D 2/1/2019 D 1/1/2019 D 12/15/2018 D 11/1/2018

into this:

 Store Date A 1 A 2 A 3 A 4 B 1 B 2 B 3 B 4 C 1 C 2 C 3 C 4 D 1 D 2 D 3 D 4

I get the sense that this will be accomplished through the group by function - but I can't figure out how! I'm open to M or Dax solutions! Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User III

## Re: Group by most recent date, then next most recent, etc

You can rank the dates for each store

```Calc Column =
RANKX ( FILTER ( TableName, [Store] = EARLIER ( [Store] ) ), [Date],, DESC )
```

Try my new Power BI game Cross the River
Super User III

## Re: Group by most recent date, then next most recent, etc

You can rank the dates for each store

```Calc Column =
RANKX ( FILTER ( TableName, [Store] = EARLIER ( [Store] ) ), [Date],, DESC )
```

Try my new Power BI game Cross the River

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors