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
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