Forum Discussion
Counter for orders
Hey guys!
I have some problems cause it`s first try to take some exp in PBI. So, I`ll be really greatful for help!
Task: I should count nums of order, for example we have first entry 12 and it`s - 1, second one - 2 and so on.
I`m trying to make it like that: counter = countrows(filter(database, [nums of order] = earlier([nums of order])))
But it`s not for me, cause that formula just count total value of entries. As I see its should be another one column like that:
| Nums of order | Counter |
| 12 | 1 |
| 12 | 2 |
| 13 | 1 |
| 14 | 1 |
| 12 | 3 |
Danke!
Anonymous , with this data you will not be able to create a counter.
Add index column first
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
the try a new column
countX(filter(database, [nums of order] = earlier([nums of order]) &&[Index] <= earlier([Index]) ),[nums of order])
6 Replies
- amitchandak
Super User
Anonymous , with this data you will not be able to create a counter.
Add index column first
https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi
the try a new column
countX(filter(database, [nums of order] = earlier([nums of order]) &&[Index] <= earlier([Index]) ),[nums of order])
- vanessafvg
Community Champion
HI i am not 100% sure about the pattern you are posting, is the table you have provided what you want to end up with, or is that what your data looks like? can you show what you want to end up with?- Fowmy
Anonymous
You need another column that can be used as an identifier for each row. Then, it will easy to differentiate each row in order to apply some ranking or count. Provide a valid data set to check.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
FarhanAhmedCan you please post some output data that you required ?
