Show Maximum value?

[MrsGG]

I have managed to create an index column that appears to be working how i need it to (i have added that total field in screenshot view)

What I would like to do is have the final view to show the maximum value of the column

so instead of showing all iterations 1,2,3 - i would just like it to show the total (max) for that item and then overall total

Can someone please help 🙂

[v-csrikanth]

Hi @MrsGG 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @MrsGG 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @MrsGG 
As highlighted by @lbendlin , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution which resolves your issue.

Best Regards,
Community Support Team _ C Srikanth.

[ronrsnfld]

Do you want this in Power Query (M Code) or Power BI (DAX)?

[lbendlin]

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-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[MrsGG]

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

[lbendlin · Accepted solution]

You can add index column starting from 1, and then replace 1 with null.