Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
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.
Regards,
Xiaoxin Sheng
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.
Regards,
Xiaoxin Sheng
thanks, I can also use the filename then to represet the dates in a column.
I'll have a go today.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |