you're content is so unique, and highly valuable from a practical point of view! and love how intuitive you have made the learning experience on this! Thank you so much for the time and effort!
Instead of using two functions - List.FirstN & List.LastN, we can use List.Range which offsets the start. I learnt about it just today & Am I glad I couse find a use for it immediately!
If you can make video on below request To ensure that your Pivot Table only reflects data from updated or modified files when refreshing based on Power Query data, you can utilize the following approach: 1. **Identify Modified Files**: In your Power Query, include a column that indicates whether a file has been updated or modified since the last refresh. You can use a timestamp or a boolean flag for this purpose. 2. **Filter Data**: Apply a filter in your Power Query to include only the rows where the file has been updated or modified. 3. **Refresh Pivot Table**: After loading the filtered data into your Excel worksheet, refresh your Pivot Table. It will now only reflect data from the updated or modified files. By incorporating this approach into your Power Query workflow, you ensure that your Pivot Table dynamically adjusts to only include data from the files that have been updated or modified.
@GoodlyChandeep I'd like to ask the same question. There is date in top row so Text.Combine is not working. How to change data type in table or list without unboxing them?
I have a question Goodly. I've been using this technique with some great success. However, how does one extract more than one column from the Table.Column function? I tried Table.Column([Table1], "Col1", "Col2") but I get the 3rd expression is missing. What do I need to do to get the 2 columns or do I have to simply repeat the applied step for my 2nd column I need?
Paul, you need to use table.selectcolumns docs.microsoft.com/en-us/powerquery-m/table-selectcolumns to be able to get multiple columns off the table. But I cannot say much unless I see the use case!
I am interested in taking your power query course. My company will be paying and I have a form that needs to be filled out. How can I contact you directly to discuss this?
Dear Goodly, could you give me some advice? I would like to write the cell content from a row into a new column, if the cell content starts with a number (digit) and the others (starts with letter/alphabetic character) into a second/separate new column. Thanks for your support.
@@GoodlyChandeep Dear Goodly, thanks for your very fast feedback. I was looking for an Excel Power Query solution. You have sent me a solution, but this is valid and working in Excel 365. I still working with Excel 2016 and this option is not available. Any idea? Thanks for your great support.
Have you thought of adding your course to udemy? There are many organizations that provide free access to the courses in udemy while you still get paid. I watch your videos and find them very useful. I think there will me many like me who can benefit if you add your course to udemy. Can you consider putting your course in udemy?
@@GoodlyChandeep You definitely should get on to that. I have attended sessions from other trainers as well and found your videos to be much more clear and helpful that I could apply in my work.
Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
you're content is so unique, and highly valuable from a practical point of view! and love how intuitive you have made the learning experience on this! Thank you so much for the time and effort!
Instead of using two functions - List.FirstN & List.LastN, we can use List.Range which offsets the start. I learnt about it just today & Am I glad I couse find a use for it immediately!
Thanks.. great suggestion!
Another excellent practical example. Thank you Goodly
You just answered my prayers of how to utilize top row data:) Many thanks
💚
Very Nice Video and explained with very effective ways.
Exactly what I needed. You are champ mate.
Glad it was helpful!
That's really a great and helpful tip thank u.
отличный урок дружище, спасибо!
Next Level Sir
.Thank You
WOW! Respect. You're the best. Thanks!!!
That's really a great and helpful tip. Looking forward to more of your videos on Tips and Tricks 👍
Thank you so much for this idea
You just save my time, great code
Love this trick..
Great .....can u help me by answering whats the difference between table.skip rows and table.remove rows?
excellent, thank you
Great video Chandeep.
Thank you, glad you liked it :)
If you can make video on below request
To ensure that your Pivot Table only reflects data from updated or modified files when refreshing based on Power Query data, you can utilize the following approach:
1. **Identify Modified Files**: In your Power Query, include a column that indicates whether a file has been updated or modified since the last refresh. You can use a timestamp or a boolean flag for this purpose.
2. **Filter Data**: Apply a filter in your Power Query to include only the rows where the file has been updated or modified.
3. **Refresh Pivot Table**: After loading the filtered data into your Excel worksheet, refresh your Pivot Table. It will now only reflect data from the updated or modified files.
By incorporating this approach into your Power Query workflow, you ensure that your Pivot Table dynamically adjusts to only include data from the files that have been updated or modified.
Excellent Goodly 😊
GREAT. Thanks.
List.Range would be better alternative to pick specific range in list @6:46
Hi..Chandeep..
It's informative and helped a lot.
In case we have 2 or 3 column table on top how do we extract ?
Thanks
Great 👍💯
Great video!!
Awesome 👍
Thank you so much for this. What can one do if one of the data in the top row is a date? Text.Combine gives an error because of data mismatch.
@GoodlyChandeep I'd like to ask the same question. There is date in top row so Text.Combine is not working. How to change data type in table or list without unboxing them?
Excellent. Appreciate
Thanks Ravi
Excellent
Hi ;Do you give certificate after the courses ?
Yes I do :)
Great video!
Glad you enjoyed it!
Cool.
Thanks a lot for the amazing video
Thanks Argo!
Guruji 🙏
I have a question Goodly. I've been using this technique with some great success. However, how does one extract more than one column from the Table.Column function? I tried Table.Column([Table1], "Col1", "Col2") but I get the 3rd expression is missing. What do I need to do to get the 2 columns or do I have to simply repeat the applied step for my 2nd column I need?
Paul, you need to use table.selectcolumns
docs.microsoft.com/en-us/powerquery-m/table-selectcolumns
to be able to get multiple columns off the table.
But I cannot say much unless I see the use case!
@@GoodlyChandeep cooool. Let me have a try, thank you so much.
Thanks. I just struggled with this. :-)
I am glad I could help! Cheers
I am interested in taking your power query course. My company will be paying and I have a form that needs to be filled out. How can I contact you directly to discuss this?
Goodly.wordpress@gmail.com
gives me error for file with extension .xls, please help
What if the data to be extracted is a formula ? It's not working in that case. Please help.
How can I see hint funciton in power query editor like you? Thank
You just need to update your Excel
Dear Goodly,
could you give me some advice? I would like to write the cell content from a row into a new column, if the cell content starts with a number (digit) and the others (starts with letter/alphabetic character) into a second/separate new column. Thanks for your support.
See if this might help www.goodly.co.in/separate-numbers-from-text-excel-powerquery/
@@GoodlyChandeep Dear Goodly,
thanks for your very fast feedback.
I was looking for an Excel Power Query solution. You have sent me a solution, but this is valid and working in Excel 365. I still working with Excel 2016 and this option is not available. Any idea? Thanks for your great support.
Hi i have same scenario but extracting .csv file from folder.
But no success pls assist
Instead of using Excel.Workbook use Csv.Document
Rest remains the same
What if the number of top rows you removed varied in the excel sheets? It was 6 here. Can we not make that dynamic? :)
A simple IF function can be written to check if the row is a header or not and then the top rows can be removed.
Very delicious !!!!
Thank you 😋
Have you thought of adding your course to udemy? There are many organizations that provide free access to the courses in udemy while you still get paid.
I watch your videos and find them very useful. I think there will me many like me who can benefit if you add your course to udemy. Can you consider putting your course in udemy?
I have just been procrastinating :)
@@GoodlyChandeep You definitely should get on to that. I have attended sessions from other trainers as well and found your videos to be much more clear and helpful that I could apply in my work.
Gr8 stuff, i can see intelli sense during writing PQ functions. Which excel version are you using pls.
This is not available in 2016.
You just have to update your excel. I am using O-365
Great .....can u help me by answering whats the difference between table.skip rows and table.remove rows?
Table.Skip - docs.microsoft.com/en-us/powerquery-m/table-skip
Table.RemoveRows - docs.microsoft.com/en-us/powerquery-m/table-removerows
@@GoodlyChandeep thanx
@@GoodlyChandeep thanx