Counter for orders

[PBI_nick]

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!

[amitchandak · Accepted solution]

@PBI_nick , 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])

[PBI_nick]

It`s work! Thank you very much! Have a nice day 🙂

[FarhanAhmed]

Can you please post some output data that you required ?

[vanessafvg]

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?

[PBI_nick]

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

[Fowmy]

@PBI_nick 

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 🙂

YouTube, LinkedIn