Forum Discussion
Show Maximum value?
You can add index column starting from 1, and then replace 1 with null.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
his is the data, i hope it copies ok.
Bascially the first instance there is no recurrence as its the first iteration the second shows 1 but should be 2 so the overall total of this one would be 11 and not 10 - its ok if that repeats on each row
| Reference | Damaged Code | Recurrence |
| 1-2017-0045 | 797.050 | |
| 1-2017-0067 | 797.050 | 1 |
| 1-2018-0056 | 797.050 | 2 |
| 1-2018-0104 | 797.050 | 3 |
| 1-2019-0043 | 797.050 | 4 |
| 1-2019-0044 | 797.050 | 5 |
| 1-2019-0107 | 797.050 | 6 |
| 1-2020-0013 | 797.050 | 7 |
| 1-2020-0042 | 797.050 | 8 |
| 1-2020-0055 | 797.050 | 9 |
| 1-2021-0033 | 797.050 | 10 |
You can add index column starting from 1, and then replace 1 with null.