topic Re: How to create an increment counter column based on how many entries a same person submit in DAX Commands and Tips

How to create an increment counter column based on how many entries a same person submit

Anonymous — Tue, 20 Sep 2022 02:06:53 GMT

Hi everyone. Can somebody help me? I am a beginner at Power BI.

The scenario is I have a table that stores data of entries submitted by employees. I want to create a column that counts incrementally whenever the same person submits an entry. The example that I want is as below:

STAFF NAME	COUNTER COLUMN
Hanis	1
Hanis	2
Faiz	1
Amira	1
Hanis	3
Syafiq	1
Faiz	2

As you can see above, when 'Hanis' submit her first entry ever, the counter starts with one. Then when she submit more entry, the counter increments. The same goes for 'Faiz'.

Can anybody help me to create this counter column? TQ in advance!

Re: How to create an increment counter column based on how many entries a same person submit

Jihwan_Kim — Tue, 20 Sep 2022 02:47:41 GMT

Hi,

I assume the table contains something like lognumber column or logdate column to identify the difference of the sampe person's each row.

Please check the below picture and the attached pbix file.

It is for creating a new column.

Counter column CC = CALCULATE ( COUNTROWS ( DISTINCT ( Data[LogNumber] ) ), FILTER ( Data, Data[STAFF NAME] = EARLIER ( Data[STAFF NAME] ) && Data[LogNumber] <= EARLIER ( Data[LogNumber] ) ) )

Re: How to create an increment counter column based on how many entries a same person submit

Anonymous — Tue, 20 Sep 2022 05:14:43 GMT

hi there, thank you so much for your reply. I believe this could be a solution but since I don't have the log number column in my table, I could not proceed with this. I tried to add the LogNumber column first but unfortunately, the PQ says that I don't have credentials or something like that. I'm not sure what is the problem but thank you anyways for your help!

Re: How to create an increment counter column based on how many entries a same person submit

Jihwan_Kim — Tue, 20 Sep 2022 08:05:15 GMT

Hi,

Thank you for your feedback.

Please share your pbix file's link (Onedrive, googledrive, dropbox, any other) here, and then I can try to look into it to come up with a more accurate solution.

Thank you.

Re: How to create an increment counter column based on how many entries a same person submit

Anonymous — Wed, 21 Sep 2022 01:11:47 GMT

Hi Jihwan_Kim,

Thank you very much for your interest to help me with this. However, I found out that my idea to use a counter is not a suitable approach for me to cater to the user requirement that I am trying to solve.

I could not share the pbix file since it is company confidential. However I have a new question instead which is more specific to what is the actual problem I am facing now. You can go to the link below to view my question and I hope you can suggest your method there. TQ in advance! This is the link:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-count-rows-based-on-two-conditions-simultaneously-in/m-p/2779370#M86931