Forum Discussion
Identify duplicate rows
But, you can convert a text inside in measure to a number using the VALUE function
Sorry for the additional questions, so when you have a docnum equal you don't want to count the repetead ones?
Can you send an example of data where you have that type of information (duplicated doc numbers) and expected result? On the first example you only had 3 lines so it's diffficult to duplicate your data and get accurate results.
Thank you in advance.
There could be more than 5000 rows in different order.
| Cost Center | GL Account | DocNo | Amount | Flag |
| 2525001 | 5455506 | DE452K | 450.11 | Dublicated |
| 2525040 | 5456000 | DE333C | 83.45 | |
| 2525001 | 5455506 | DE477B | 450.11 | Dublicated |
| 2525002 | 5455506 | DFG56B | 36.9 | |
| 2525003 | 5455506 | DFKB90 | 50.01 | |
| 2525004 | 5455506 | DFKB90 | 35.04 | |
| 2525002 | 5455506 | DFG56B | 36.9 |
This Column "Flag" should be the result. I am looking for a pattern with specific rules.
For this cinaria you need like this
https://1drv.ms/u/s!AiUZ0Ws7G26RhjCoMtuTrBnmXanZ?e=z5Kwd7But what If the Cost Center or the GL Account is not a number. It is a text field.
But, you can convert a text inside in measure to a number using the VALUE function