cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Monthly Trend Reports via Sharepoint

I create monthly reports using Excel and the Power Pivot and Power Query(mostly) tools. 

I connect to sharepoint for my source files and grab the data from there and create these reports. 

 

I update the source files each month and make the new reports. However i also feel i need to have trend charts for the growth of data across the months/quarter/year. 

 

Not sure how this can be achieved. 

 

Is there a way i can setup a folder structure in Sharepoint like 2016 -->Jan/Feb/each month as a subfolder within and add all the source files within each month and then create trend charts from these?? 

 

P.S: Using the Power BI Desktop client is not an option for me. Only Power Query and Power Pivot. 

 

 

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)