Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
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.

1 ACCEPTED SOLUTION
Anonymous
Not applicable
3 REPLIES 3
Anonymous
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!




Anonymous
Not applicable

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.