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.
