Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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-sim...
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] )
)
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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!
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
42 | |
26 | |
21 | |
16 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |