Forum Discussion
Count rows with same code
- 2 years ago
you can try to create an index column in pq
then use DAX to create a column
Column = CALCULATE(count('Table'[country]),FILTER('Table','Table'[country]=EARLIER('Table'[country])&&'Table'[Index]<=EARLIER('Table'[Index])))if you have a datetime column, you can use that instead of the index column - 2 years ago
Hi ryan_mayu ,
thanks for your answer. I tested and it works! It's amazing!. I would never have achieved it and I am extremely grateful that knowledge can be shared in this community. Thank you very much for your help and Anonymous and vicky_ who have also wanted to help me with this, for me, difficult problem.
Thanks again to this community.
José Luis
Hi ryan_mayu ,
thanks for your answer. I tested and it works! It's amazing!. I would never have achieved it and I am extremely grateful that knowledge can be shared in this community. Thank you very much for your help and Anonymous and vicky_ who have also wanted to help me with this, for me, difficult problem.
Thanks again to this community.
José Luis
you are welcome