Brilliantly done and explained! So very easily understood a task that was seemingly impossible to me until a short while ago. This is exactly what i was searching for. Thank you. 💯
Omg this is wonderful! I have been newly experimenting with Power Query to create a financial model. And I have these crazy formatted reports that are so different from what most coaches are sharing. I love that you took one of those crazy reports into consideration and created this video! Thank you for the Bonuses!
Great job man ! Sincerely but your filter lack the option to return to the "All record view". I do appreciate the combination of python and powerquery that is kinda unique in this channel
I have an spreadsheet with multiple invoices paid over many years. These invoices are grouped under each cost component and element mentioned in the same column but one after the other in rows. And then all the invoices based on their vendor name in the same column the invoice details besides them. Im trying to clean this data up by having the Cost component in seperate rows, and the vendor name in the 3rd column. Im struggling with this!
This was an excellent video and easy for me to follow along and very timely for what I'm working on.
Thanks for sample file
i can follow your video
step by step
thanks very much
Brilliantly done and explained! So very easily understood a task that was seemingly impossible to me until a short while ago. This is exactly what i was searching for. Thank you. 💯
Omg this is wonderful! I have been newly experimenting with Power Query to create a financial model. And I have these crazy formatted reports that are so different from what most coaches are sharing. I love that you took one of those crazy reports into consideration and created this video! Thank you for the Bonuses!
व्हिडीओ खूप छान आहे. ज्ञान चांगले दिले. मात्र व्हिडिओ मध्ये खूप वेगात समजावले आहे. याचे दोन व्हिडिओ करून सावकाश सांगितले असते तर बरे झाले असते
very nice, informative, practical approach, Thanks
this addresses a practical scenario very well. good job!
thank you
Thanks for this..
All the best and waiting to see more such contents😁😁
Excellent video, very informative, thanks a lot
Very Good Explained
Thanks, just started learning power query and I benefit greatly for your transforming of that messy sheet.
Great job man ! Sincerely but your filter lack the option to return to the "All record view". I do appreciate the combination of python and powerquery that is kinda unique in this channel
🎉 useful
Very informative vedio 👍
Awesome.
Well explained.
Thanks, very helpful 😊
👍
great videi
Fantastic video
Thanks! 😃
Simply use slicer to select the applicant name
thanks a lot
When filtering, instead of capitalize the criterion, you can ignore the case with "Comparer.OrdinalIgnoreCase" as 3rd argument of Text.Contains
Thank you for your video. I followed the steps when getting the second data but the final report didn't update, can you help explain?
super❤
What if the applicant name is left blank? Will it back to previous table data?
I have an spreadsheet with multiple invoices paid over many years. These invoices are grouped under each cost component and element mentioned in the same column but one after the other in rows. And then all the invoices based on their vendor name in the same column the invoice details besides them.
Im trying to clean this data up by having the Cost component in seperate rows, and the vendor name in the 3rd column.
Im struggling with this!
🙌
Hi what if I want to keed the extracting date into a new column? How should I do that?
The '31-Jan' that are in O4 cell
Bro can you help me with one question.??
@11:56 which video does explain this? Cant find it on your page pls
Hello, link for the video - Handling Change in Source Data in Power Query
th-cam.com/video/fNZYTwMuSZI/w-d-xo.html
What to do row no r not matching
Hi Thinking DataScience,
Is it possible to display all information if cell A2 in Outstanding_Final_Report_Transformed sheet is blank or null?
Need to work on Communications too along with Data science!