Good explanation. Personally, I think it's easier to go to Advanced Editor in Power Query and copy the script and paste it to the other sheets and just change the Name of the region.
Great videos you have made. Very good style of teaching ! One question : why isn't the appended data showing the commision in percentage as you have selected for the column type?
Hi Sumit! Thanks for all the great videos you have posted. They are very helpful. I have a question relating to this video: Is it not possible to create a query once for East and then just copy the steps and apply it for the other tabs ie West, North & South?
Great video Sumit .I had a doubt while appending queries even though we change the commission format to % it still shows as decimal format.What can be done about it.
Exactly what I was looking for, thank you. Is there a way to name the Region by formula, using some reference like source.TableName (which is a made-up thing)?
Hello sir thank you for your knowledge transfer pls let me know how to combine all excels together using Power query when the columns are not same in excels
Sumit Thank you very much. I wonder if you can advice me. I have applied many queries to one work-sheet (say, 19-20). I did not use folder and imported the worksheet in the power query. Now, I need another similar worksheet from another year (20-21) and I wish to combine them. However, I wish that all queries applied to first sheet also needs to be applied for the second sheet. I will be grateful for your advice please
Hi summit, In order to update when original data changes, is it necessary to have the original changed date in same sheet ? E.g. I have appended June data of four regions and now i have the July data, do i need to copy the July data in the same sheet containing the appended data ? or we have to replace the June data with the july data in the same worksheet ?
Hello Sir, Excellent tutorial. However, I have a problem at hand. I would like to use power query to read files and folder data on a daily basis and append to the table till yesterday. So I want this to add these as transactions on a daily basis. So on day 1, I will use get data from files and get all the fields like date, path, extension, etc. However on day 2 and forward, I wish to append new data from files and folder to my existing table. Please help solving this issue.
Hello Sir, Thanks for this vdo. however, when I clicked on file -> Close to load tab I m getting 'only create connection' option disable. M I mssing here something? Please help. Thanks in advance.
Hi I am facing similar problem but I need to combine sales data from 1 master file to multiple 4 files with selected columns. Is it possible ? Pls help
When I click on "close and load to..." Only two options are shown in the box, Table and Only create connection. PivotTable Report and PivotChart options are missing. I am using Excel 2016. What is the problem?
Hi Sir, After loading data in power query I'm not getting query name directly as region name. I have to do it manually. Can u please tell me why or I'm missing any step? Thanks in advance
Sumit Sir thanks to you for this free video to understand power query with so ease and simple language.
I love that this video exist to help my work becoming easier. Thank you!
Thank you so much! Your channel is one of the best Excel tutorial channels on TH-cam. Your videos have saved my life so many times!
Thank yiu so much man. It was really helpful for me. Recently , I have used it for my office workwork and that was great.
Nice work - thank you
This is just what I was looking for. Thank you!
Thank you Sir. Your step by step video guide was very informative and well paced.
I love your demonstrations. They are detailed and that's great. I have a question. What to do if we add a new worksheet to the existing ones?
Exactly what I was looking for! Great explanation too! Thank you so much!! ;)))
Good explanation. Personally, I think it's easier to go to Advanced Editor in Power Query and copy the script and paste it to the other sheets and just change the Name of the region.
Great explanation. Thank you.
Thanks for commenting Alex... Glad you found the video useful!
Great .... thank you so much
I need this information. Thanks a lot
Great videos you have made. Very good style of teaching ! One question : why isn't the appended data showing the commision in percentage as you have selected for the column type?
its really helpful .. thanks dear
Glad you found the video helpful 🙂
Thanks so much.
Hi Sumit! Thanks for all the great videos you have posted. They are very helpful. I have a question relating to this video: Is it not possible to create a query once for East and then just copy the steps and apply it for the other tabs ie West, North & South?
Hi There, thanks for explanation. Could you explain to me how to do complex reconciliation of transaction?
Hats of thanks
Great video Sumit .I had a doubt while appending queries even though we change the commission format to % it still shows as decimal format.What can be done about it.
Exactly what I was looking for, thank you. Is there a way to name the Region by formula, using some reference like source.TableName (which is a made-up thing)?
Hello sir thank you for your knowledge transfer pls let me know how to combine all excels together using Power query when the columns are not same in excels
Do u have videos on power pivot
Thanks
Sumit
Thank you very much. I wonder if you can advice me. I have applied many queries to one work-sheet (say, 19-20). I did not use folder and imported the worksheet in the power query. Now, I need another similar worksheet from another year (20-21) and I wish to combine them. However, I wish that all queries applied to first sheet also needs to be applied for the second sheet. I will be grateful for your advice please
Hi summit,
In order to update when original data changes, is it necessary to have the original changed date in same sheet ? E.g. I have appended June data of four regions and now i have the July data, do i need to copy the July data in the same sheet containing the appended data ? or we have to replace the June data with the july data in the same worksheet ?
Is there a way to add a column to each of the data tables in power query based on the table name?
Hello Sir,
Excellent tutorial.
However, I have a problem at hand.
I would like to use power query to read files and folder data on a daily basis and append to the table till yesterday.
So I want this to add these as transactions on a daily basis.
So on day 1, I will use get data from files and get all the fields like date, path, extension, etc.
However on day 2 and forward, I wish to append new data from files and folder to my existing table.
Please help solving this issue.
Could I create a column named as te table name, automatically?
Hello Sir, Thanks for this vdo.
however, when I clicked on file -> Close to load tab I m getting 'only create connection' option disable. M I mssing here something? Please help. Thanks in advance.
Hi I am facing similar problem but I need to combine sales data from 1 master file to multiple 4 files with selected columns. Is it possible ? Pls help
When I click on "close and load to..." Only two options are shown in the box, Table and Only create connection. PivotTable Report and PivotChart options are missing. I am using Excel 2016. What is the problem?
sir while am selecting the append option am not getting option three or more tables its showing single table option am using 2016 version
Hi Sir,
After loading data in power query I'm not getting query name directly as region name. I have to do it manually. Can u please tell me why or I'm missing any step?
Thanks in advance
thks dear. 1303 rows finsl but when i add indivisual rows it is more say 1315 rows... why?? pl advise
Any chance you are counting the header row of each table, as the final result only has one header row
@@trumpexcel no. i solved the issue with locale!@
any one please suggest me
Thanks!