There is a lot of post about this but a can't seem to make this work.
Here is my data table.
I want to have a test book that displays the total of the Fee Amount colour. I have tried sum(Sales_Pipeline, "Fee Amount") but nothing is returned.
What am I doing wrong?
Hi @LaingBennett ,
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Assuming that fee amount is the name of your column (which contains a space), you should try using single quotes instead of double quotes.
Sum(Sales_Pipeline, 'Fee Amount')
If the value that this returns isn't correct, it will most likely be related to delegation issues if you're using a SharePoint list as your data source.
Hi @LaingBennett ,
For the Data table, you can use the Same code for Sum All records.
"Total Sum "&Sum(GroupByTest,'LINE No')
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay
I have tried this and can't get it to show any data.
I have just moved the data into a Google Sheet and can't get a value to return either.
This should work, so I'm not quite sure why it's not showing any data for you.
To confirm whether or not this is a delegation issue, how many rows do you have in your spreadsheet?I notice in your original screenshot, there is a red error icon against your label. Can you tell us the error message that appears against this label?
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.