Power Platform Community Forum Thread Details

Long time lurker first time poster. I'm going nuts and hoping someone can help. I'm in Power Apps using data from a SharePoint list.

Data

Project Name	FY	Month	Spent	ReportDate
(lookup)	(number)	(text, ie. Jan, Feb, Mar)	(currency)	(date)
ProjectA	22	JAN	10	1/15/2022
ProjectA	22	JAN	5	1/15/2022
ProjectB	22	JAN	8	1/15/2022
ProjectC	22	JAN	9	1/15/2022
ProjectA	22	FEB	12	2/15/2022
ProjectA	22	FEB	13	2/15/2022
ProjectB	22	FEB	18	2/15/2022
ProjectC	22	FEB	19	2/15/2022

I have a power app that asks the user for the FY via dropdown and the project name via dropdown.

FY dropdown: Distinct('DataSource'.FY,FY)

Project dropdown: Sort(Distinct(Collection,ProjectName.Value),Result,Ascending)

*note ProjectName is a lookup therefore .Value added*

I'm trying to chart data for each selected Project by Month. I can successfully chart the data for the individual rows but I can't figure out how to sum the spent column for a given project in a given month.

Intent:

The user selects Project A. The chart shows the summation by month (aka TotalSpent in JAN, TotalSpent in Feb, etc) for the selected project. The need for two columns to be the same (Project A and Month) to then sum the 'spent' column while ensuring I have the TotalSpent & Month for the chart is driving me nuts. I also need to use ReportDate, or have in the past used it, to sort the data ensuring the x-axis is in the correct order. Note there are some projects that are not duplicated though I hardly think that matters I presented the info as such.

Any assistance you all can provide is appreciated.

Categories:

Using Apps Using Formulas