Answered

Chart from SharePoint

(0) Share

Report

Posted on by adecaes

Hi All,

I think I'm trying to do something quite simple and it may be a beginner question but can't get the right formula... I have a SharePoint list where I store my expenses: Date and Price, and I want to generate a chart that will show the cumulative expenses through time.

I've tried something like this : AddColumns(expenses;"Val";Sum("Price")) but the only thing I get is each expense for the day associated...

Thanks in advance for your help !

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

CarlosFigueira Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
You first need to group the expenses (by Date, I'm assuming) using the GroupBy function, then you can use the AddColumns to get the sum of all expenses for that day, something along the lines of the expression below.

AddColumns( GroupBy(expenses; "Date", "ByDate"); "Val"; Sum(ByDate; Price))

Take a look at the documentation for GroupBy, it will have many examples of what you are trying to do.

Was this reply helpful? Yes No
adecaes 13 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks of rtaking the time to reply

I know this is a basic question, but I already tried the groupby formula you add and I only get the distinct price on my chart... could I be missing something else ?

Was this reply helpful? Yes No
v-micsh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @adecaes,

What is your current situation?

Have you checked the GroupBy function reference?

GroupBy in PowerApps

Please show the data within a gallery (with the formula suggested by Admin CarlosFigueira), and then check to see if you could get the proper organized prices with the corresponding date.

Or you may share a sample data that you would like to show, we will then check to see if a proper solution could be offered.

Regards,

Michael

Was this reply helpful? Yes No
Verified answer

adecaes 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for asking, no the group by did not help me doing what I wanted.... but I did found a workaround using a Filter function and a Sum on the result 🙂

Was this reply helpful? Yes No