2 ай бұрын
2 ай бұрын
4 ай бұрын
Пікірлер
@Dexter101x 3 күн бұрын
You need to work on your audio, its way too low
@KKB-tt4lj 3 күн бұрын
Interesting but no file to follow along...
@kebincui 8 күн бұрын
Thank you for this excellent video👍❤. I have a question: I understand that for large dataset which Table.Buffer is necessary. For small data set such as a few hundred rows, will I get the wrong result if I do not buffer the table before removing duplicates? Please advise. Thank you in advance.
@kebincui 8 күн бұрын
I found the answer. Thank you any way for this excellent video.
@ziggle314 11 күн бұрын
Very interesting discussion on the use of the Table. Buffer command. I have seen some strange behavior that Table.Buffer may solve. Thanks for the excellent work.
@excel4urparents242 11 күн бұрын
Thanks for the continued support!
@maptrking 15 күн бұрын
Elizabeth - Your videos are OUTSTANDING!! I LOVE them all and have bookmarked all of your playlists! THANK you so much for everything!
@amguit 24 күн бұрын
Do you have a video that shows how to use power query in order to sort data by financial year, like Oct-Sep? So it knows Oct is Q1.
@amguit 24 күн бұрын
This was great. Really appreciate your teaching style! Need to leverage this group by feature more.
@excel4urparents242 23 күн бұрын
Glad it was helpful!
@johncrump328 25 күн бұрын
Nice info. Your mic picks up a lot of extraneous, distracting, needless sounds, e.g., keyboard buttons, keyboard/table pounding, mouse clicks, and saliva sounds.
@patrickdowe208 27 күн бұрын
This is brilliant. Thank you. What if I'm trying to get clusters of the lead addresses, i.e., grouping addresses that are close to each other.
@saichandu5965 Ай бұрын
Wow Well can you able to do one video on how to get the data from other folders within the shared drive and look up the data from multiple datasets located in diff shared folders in teams...
@aungthuhein007 Ай бұрын
I always thought merging queries always created a new query. This is cleaner. Thanks!
@austinbushnell7448 Ай бұрын
Excel + VBA + PowerQuery is a marriage made in heaven. Leila Gharani who? There's a new Excel sheriff in town ❤
@cablegurl328 Ай бұрын
I found your channel and learning Power Query now on my own. As I go through the guide of combining data from multiple sources, how will that impact my dataset if my source adds additional columns down the road?
@excel4urparents242 Ай бұрын
Hi! Thanks for the comment. If you add a new column to any of your data sources, it should come through upon refreshing. Some exceptions/watchouts to this are if you have your data grouped before appending or if you unpivoted your data (you still can unpivot your data before appending tables and have a column flow through. You just have to use the "unpivot other columns" function). If the new column is only on some of your data sources, it will return a null value for the value in any table that doesn't have that column but will flow through for others.
@patrickschardt7724 Ай бұрын
I will have do this immediately. I have multiple project BOMs with outsourced parts that also have cost adjustments (discounts, markups, etc) I use Power Query to handle the appends/ merges and adjustments. I should do this to print the pdfs
@excel4urparents242 Ай бұрын
I’m so glad you found it useful, thanks for the comment!
@patrickschardt7724 Ай бұрын
One of the best if then else Power Query tutorials I have watched. Great job
@patrickschardt7724 Ай бұрын
Just found your channel and I’ve gone through most of the videos already Wonderful tutorials. Also the way you said delimiter reminded me of the Deluminator from Harry Potter which makes me smile
@Weehawk Ай бұрын
Speaking of dates, how about you and me, Friday night dinner athe Sizzler?
@mattschoular8844 Ай бұрын
Thanks for sharing your knowledge. Quick question, why do you press CRTL A when you can simply press CRTL T to create a table from the raw data set?
@ziggle314 Ай бұрын
Nice job. I like seeing a good application for the geographic data type. Thanks!
@teekayjunior2517 Ай бұрын
Love your channel and teaching style. I’m not a technical wiz when it comes to producing content, but I’m sure there’s a way to tune your mic so there is no echo and improve your listeners’ experience.
@excel4urparents242 Ай бұрын
Great suggestion; I will see what I can do about that!
@naturelover7998 2 ай бұрын
Finally found the solution, thank you so much for video. great Job...
@excel4urparents242 2 ай бұрын
I’m so glad you found this useful, and it was able to help.
@kebincui 2 ай бұрын
Excellent 👍❤
@ebenezerasare9934 2 ай бұрын
Do you have any live courses in Power Query. Would love to join
@excel4urparents242 2 ай бұрын
Hi! Not right now, but possibly in the future!
@ziggle314 2 ай бұрын
Good example. I process battery test data. Very similar to the analysis you show here. Thanks!
@excel4urparents242 2 ай бұрын
I’m glad it was relatable !
@richardmensah3327 2 ай бұрын
any alternative for the "same period last year" calcuations in power query?I mean easier to grasp method.
@richardmensah3327 2 ай бұрын
The data type for the "Age" column should be changed to whole number I guess.Unless because you did'nt use it for your analysis
@richardmensah3327 2 ай бұрын
No dataset for us to try our hands on!
@excel4urparents242 2 ай бұрын
Hi! Thanks for the comment; the link to the dataset is now in the video description.
@ziggle314 2 ай бұрын
Excellent example of a simple automation that can save a lot of time. Thanks!
@Locomaid 2 ай бұрын
Good stuff! Just a quick hint: you do not need to select all with ctrl-A tommake a table. Clicking anywhere in the range and using ctrl-T is enough.
@ziggle314 2 ай бұрын
Nice work. Thanks!
@7213261 2 ай бұрын
Thanks!
@BaniMoniah 2 ай бұрын
Don’t write the “dot” when writing the formula, continue writing the formula and press Tab, this will solve the extra writing
@ziggle314 2 ай бұрын
Very important!
@patrickschardt7724 Ай бұрын
For some reason they still won’t fix this. It’s been around for a few years and that workaround is very helpful
@ExcelUpNorth 2 ай бұрын
That was a great solution to show year-over-year YTD revenue and I like how you went about troubleshooting the error 😀 By the way, the left video of your end screen is blocking the refreshed pivot table.
@excel4urparents242 2 ай бұрын
I'm glad you liked it! Thank you for letting me know about the end screen, I just fixed that!
@ExcelUpNorth 2 ай бұрын
@@excel4urparents242 Looks good!
@Locomaid 2 ай бұрын
@@excel4urparents242 Hi! Thanks for the great video! FYI The end screen issues are either not fixed or not replicated through.
@kebincui 2 ай бұрын
Super👍
@kebincui 2 ай бұрын
Excellent 👍 🌹
@kebincui 2 ай бұрын
Excellent tutorial 👍❤🌹
@vergelmer1 2 ай бұрын
Great , but I can't convert 02/2024 format as a sample to date
@excel4urparents242 2 ай бұрын
Thank you for the comment! When I tested this, I found that selecting the Data Type as Date defaulted the date to the first of the month. After that, you can proceed to parse out the month and year using the Add Columns feature. Alternatively, in the Power Query editor under the Home tab, you can split the column by delimiter "/" to create separate year and month columns. It would be the month number at this point, but you can write a conditional-if column to get it to month names or create a new Customer column using the date syntax #date(year, month, day) to put it back into a date.
@algr665 2 ай бұрын
Very clear and concise tutorial. Keep them coming, please. This is helping me a lot in my new job doing data analysis. Thank you!
@excel4urparents242 2 ай бұрын
I am so glad!! is there anything specific you would like a video focusing on?
@algr665 2 ай бұрын
I think any "data analysis" tools have become the core of many functions in most medium and large sized companies. The typical Excel even with advanced formulas techniques (which are still usable) is no longer the only valuable skills for many professions. I've been using Excel with complex formulas in my work for years, but learning Power Query, Power Pivot, Power BI, and Data Analysis in ChatGPT 4.0, just to cite some examples, have become a priority. if it wasn't for tutorials like yours and others in KZbin I wouldn't be able to achieve my renewed professional goals. The least I can express in this reply is my most sincere gratitude. You have a natural talent for teaching and coaching. It shows in your videos. Thank you!!@@excel4urparents242
@user-rg8vi7ct2r 3 ай бұрын
Hi, is a car dirving distance? or is a air line distance between two points?
@excel4urparents242 2 ай бұрын
Hi! This is a direct line distance between two points.
@user-fy1ng5xd5i 3 ай бұрын
Can we deliver this using sql server only?
@warrenanderson412 4 ай бұрын
You should record this over..too many skipping and timing is off
@lorismetro7729 4 ай бұрын
I don't understand what is "lead" and why you created other columns labeled with "lead". By the way this is a great video. Thank you.
@excel4urparents242 4 ай бұрын
Hi @lorismetro7729 I'm glad you enjoyed the video! A lead is a sales term meaning a potential customer or prospect who has expressed interest in a product or service. I know there are many different uses for distance calculations, I come from a sales analytics background, so I put it in this context. Thank you for mentioning it, I will try and use more generic terms in the future!
@alexandercraft4882 Жыл бұрын
☝️ 『p』『r』『o』『m』『o』『s』『m』