
Hello,
Hopefully, someone here will be able to help me. I have a weekly spreadsheet connected to my Power Apps. I would like to create a chart in Power Apps connected to it. I don't want the chart to display all the weekly data but rather an average per month. How can I collect my data to show it on a monthly basis? I have three years' worth of weekly data. The idea is to display the monthly average for the last three years.