How to create an increment counter column based on how many entries a same person submit
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!