Forum Discussion
Show Maximum value?
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 🙂
You can add index column starting from 1, and then replace 1 with null.
7 Replies
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/1447523his 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.
Do you want this in Power Query (M Code) or Power BI (DAX)?
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.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.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.
