I wan to know the occurance of each number as a transaction. I.e 1st transaction, 2nd transaction etc based on the count of its duplicate values. how to convert this formula in XL to power bi Countif($A$2:A2,A2) ? Need the same result
It shows the number of duplicated values of each number in the coloumn. if you see 3342 it has repeated the 2nd time next this means its the 2nd time it has come in if 3 then 3rd time etc.
The solution you have shown would give me a total count of each number but but the individual occurance. If you see the data refelcts each transaction by a number. hypothetically ,suppose there is a numeber 9842124555 if he has transacted for 1st time the count in the adjacent column would show 1 and in another column it would show 9842124555. Now again if he transacts it the 9842124555 would still be displayed in a new row but the count would be 2.
This is finding each duplicates in a column which enables to track each transaction by a user. what is his/her 1st transaction, 2nd transaction etc.
I am able to do so in XL using Countif but not able to figure out how to do it in Power BI