Data help

[jblackburnHWGA]

I need a bit of help with some data I have. We're collecting a set of data each month from 9 schools. The data is always the same but just represents the last 3 months. I have a master excel doc that I'm using and putting the data into tabs. The tabs are labeled with the month and year. 

This pulls in as a table per tab. At the moment it's only two tables strong but will grow with time. I can visualise the data to represent that quarter but how do I start to use the data to represent change over time?

I'm need to append with an added collection data column?

Not all the data is able to be shown over time, does that change anything?

[lbendlin · Accepted solution]

Instead of using different tabs I would recommend to split the data into different Excel files. That will allow Power Query to ingest a list of Excel files from a folder, regardless of how many files are in there.

You can then use additional Power Query transforms to deduplicate the data if needed.

[Anonymous · Accepted solution]

Hi @jblackburnHWGA,

Does lbendlin's suggestion help with your requirement? If not, you can also take a look at the following blog about combine multiple sheets in one excel file if it meets your scenario.

Combine Multiple or All Sheets from an Excel File into a Power BI solution Using Power Query Dynamic... 

Regards,
Xiaoxin Sheng

[jblackburnHWGA]

thanks, I can also use the filename then to represet the dates in a column.

I'll have a go today.

[lbendlin · Accepted solution]

Instead of using different tabs I would recommend to split the data into different Excel files. That will allow Power Query to ingest a list of Excel files from a folder, regardless of how many files are in there.

You can then use additional Power Query transforms to deduplicate the data if needed.