Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Rank by Dates and Customer ID

I have a data set that contains billing information that includes customer id, bill date, and other relevant information. A customer may have received more than one bill in a month so I'd like to "rank" the bills by date created so that I can graph the customers bills in order by that index rather than the bill date.


There are ~400,000 customers and 4 million bills in the data set.


How do I create an index or rank by Customer (using customer id) and then ascending by bill date? I assume I can use RankX but I'm having issues getting it to work correctly.

Not applicable
Not applicable

Never mind, I figured it out thanks to another post on the forum.



@Anonymouswould you mind posting the solution you found to help future people with similar questions?

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

Proud to be a Super User!

Not applicable

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors