Forum Discussion
Counter for orders
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])
The main idea is show in the table. At the end i`ll have:
| create_datetime | total sum (sum of orders) | nums of orders | counter |
| some data | some data | 12 | 1 |
| some data | some data | 12 | 2 |
Something like that if i understand u correctly. Doesnt show data in two first columns cause it neednt as I think
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 š