Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

incremental column in Power BI

Hi Folks, I need small help. How to add incremental column in power bi, my source is tabular model i need add one column to display 1 to 50. Note: Without using Rank and without touching my model i ...
Need Help
Tips and Tricks
Tutorial Requests
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

If you don't want to use Rank(), you can try this:

1. Sort the Paid Amount column by DESC in power query editor

2. Create an index column start from 1:

3. Close and apply power query editor, put this index column into the table to get the number 1-50 which is sorted by Paid Amount column

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.