Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Solved! Go to Solution.
This worked once I wrapped my head around how to do it.
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?
Proud to be a Super User!
This worked once I wrapped my head around how to do it.