Answered

How to Group data by Month from list of dates

(0) Share

Report

Posted on by balachandra

Hello, I am having an excel sheet which contains Date(mm/dd/yyyy), Colum1, Column2. I am reffering this excel sheet as my data source.

In my power app screen, I inserted a listbox. This list box should display list grouped by Month instead of dates. Can someone help me how group by Months having a collection with date?

Also, Can you help me how to perform operations on collections? Example, I need to create a pie chart by sum of Column1 & Column2 from the collection.

Atatched is screen shot. I need to display Year-Month (2016-DEC, 2017-JAN etc) instead of by week. I need sum of all Lines in pie chart (Column1+Column2+Column3+Column4)

https://1drv.ms/i/s!AuLElRm7ChiimDEWckXRmYnG_zcj

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

balachandra 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello All, Any help on this one?
Verified answer

irinak Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi balachandra,

If your data is fixed in the excel table, you may want to copy it to a collection in a way that works for your chart.

Here are a couple of tutorials that cover different Date and Time formatting options:
https://powerapps.microsoft.com/en-us/tutorials/show-text-dates-times/
https://powerapps.microsoft.com/en-us/tutorials/function-datetime-parts/

This tutorial covers scenarios on transforming data in collections:
https://powerapps.microsoft.com/en-us/tutorials/function-forall/

Best regards,
Irina
balachandra 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Irina, Thanks for your input.

I made some progress on data in collection.

Basically either you create a new collection or add one more collection using ForAll.

Thanks a lot...