cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
lmmccrae Frequent Visitor
Frequent Visitor

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

Accepted Solutions
lmmccrae Frequent Visitor
Frequent Visitor

Re: Rank by Dates and Customer ID

3 REPLIES 3
lmmccrae Frequent Visitor
Frequent Visitor

Re: Rank by Dates and Customer ID

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

 

 

KHorseman Super Contributor
Super Contributor

Re: Rank by Dates and Customer ID

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


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
lmmccrae Frequent Visitor
Frequent Visitor

Re: Rank by Dates and Customer ID

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 25 members 973 guests
Please welcome our newest community members: