Forum Discussion
Anonymous
6 years agoNot applicable
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...
- 6 years ago
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])
amitchandak
6 years agoSuper 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])
- Anonymous6 years agoNot applicable
It`s work! Thank you very much! Have a nice day 🙂