Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi there,
Fairly new to PowerBI and looking for some help.
I have around 60 excel files structured as follows:
Filename: Apr 20 Sheets: 2017, 2018, 2019, 2020
Filename: Apr 19 Sheets: 2017, 2018, 2019
Filename: Apr 18 Sheets: 2017, 2018
Filename: Apr 17 Sheets: 2017
These are point in time files. So the "Apr 17" file incudes all data for the 2017 year asat 30/04/17. The "Apr 19" file also contains data relating to the 2017 year, but is asat 30/04/19
Here's what i need to do;
Help would be much appreciated.
Thanks
Solved! Go to Solution.
Hi @MrToast20
All of this is possible using Power Query, please refer to this article to give you an example of how to do it
Regards
Phil
Proud to be a Super User!
Hi @MrToast20
All of this is possible using Power Query, please refer to this article to give you an example of how to do it
Regards
Phil
Proud to be a Super User!
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |