Consolidating training records to run reports

TXNCPO

New Member
Joined
Nov 1, 2011
Messages
34
Office Version
  1. 365
Platform
  1. Windows
Newbie (sort of) I've watch HOURS of video and even tried CHAT GPT, but I'm missing "something" I'm begging here.

I have 5 separate MS excel files, one for each of the employees. Each workbook had three "tabs" Core, Intermediate, and Advanced. I know (think) what I need to do in Power BI Desktop, is merge/append the data from all 15 (5 workbooks with three tabs) sources into one table/query? In my head this gives me the "nut" of information (the training names are unique across the three areas) to use a table/query of "AllTraining_Req" to produce reporting about what has been done and what needs to be done. I have played with DAX and feel like if I can get passed generating the "nut" of info, I can struggle bus from there. When I use "get data" from Folder, I am lost as to how to get ALL the completed training to show up, the Combine only seems tom pick up some of the data from the 5 workbook/three sheets. I really feel like i'm missing an easy step here, but after a week of trying to figure it out on my own. Guna have to set down the pride and ask for help. Thank you V/R Joe
 
There’s no magic button you’re missing; it’s an advanced concept. I wrote this blog a few years ago that will help you. There’s lots of steps. Read it once then follow step by step. It assumes all sheets are structurally the same.

 
Upvote 0
Sir, Thank you for your detailed response. I will provide any feedback after reviewing the You Tube and related comments (in case someone had the same question I did/will) I very much appreciate it. V/R Joe (guy who bites off more than he can chew sometimes, LOL)
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,918
Members
453,766
Latest member
Gskier

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top