I've created a dropdown where i can select all authors from my sharepoint listDistinct(datasource,author.displayname)
But then i want to sum a column from the list by the selected author.
I hope you can guide me in the righ direction.
Go to Solution.
Could you please share more details about the data structure of your SP list?
Is the author a custom Person type column in your SP list or the System column?
I have made a test on my side, please take a try with the following workaround:
Set the Items property of the Dropdown control to following:
On your side, you should type:
Set the Text property of the Label control to following:
On your side, you should type the following formula:
Sum(Filter(datasource, author.DisplayName = Dropdown1.Selected.Value), ColumnName)
More details about the Filter function, please check the following article:
View solution in original post
This works as expected.
To make it a bit more complicated, is there a way i can add a date picker to filter the amount greater than a specific date?
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand