Whoa that error message trick is insanely good. Thanks for sharing!
@GoodlyChandeep Жыл бұрын
Thanks Alex :)
@YvesAustin6 ай бұрын
Found this gem in my feed today. I’ll have to bookmark it! Awesome tricks. Thank you 🙏
@b0rme Жыл бұрын
Thanks for the video, and I like the tips. However I suppose queries 'breaking' and Power Query being sensitive is actually a good thing. It ensures that data sources and the structure of the data remains consistent. Nothing ever just 'breaks': there is always a good reason for why the query stops working.
@bommyTomTim Жыл бұрын
To be fair it could entirely depend on your purpose. The reason I say that is because for I use power query to track employees workload. How many items they actioned and time taken to complete. Due to the majority of information being manually inputted by end users, there is always someone that enters a weird value or made a change, they didn't know they made. End users just generally know "Thing did not work" Even though they are excel workbook is managed by the manager, there is always someone that "breaks" something. Being able to have these accounted for while still gathering the correct data is beautiful.
@jerrydellasala7643 Жыл бұрын
Great video as always. I notice your function is documented. I'd love to see a video on how to add that to a custom function. Also, how to convert a query into a function where the function becomes a new query linked to the original query so that changes made to the original query get passed to the function automatically the way it happens when using Get Files from Folder.
@Chillman666 Жыл бұрын
Cool stuff as always! Personally I like receiving error messages that certain column wasn't found because I would like to know right away if an essential column was renamed or removed from the reports
@tonydreisenstock Жыл бұрын
I have learnt so many really clever automations from you. Your videos are clear incisive and extremely effective. Thank you so so much
@GoodlyChandeep Жыл бұрын
You're very welcome Tony :)
@lourdesdelcampo87223 ай бұрын
These are great!, will be using some if not all of the tricks here, thank you
@RichardJones73 Жыл бұрын
Excellent video. It really helps to identify errors this way, saves hours of searching. And for the dynamic loading of columns is another game changer
@GoodlyChandeep Жыл бұрын
Thanks Richard :)
@advrohitowhal9794 Жыл бұрын
Error Reason & Message Trick was Awesome!
@kuldippandey9672Ай бұрын
I would like to get the confidence of creating the ignore function which you did
@s1ngularityxd64 Жыл бұрын
really cool stuff, love the error handling part😊
@GoodlyChandeep Жыл бұрын
Cheers :)
@udayteja6595 Жыл бұрын
Expanding list of tables dynamically is cool...
@oscarmendez-roca9181 Жыл бұрын
Awesome set of tricks, thanks a lot Chandeep. I have a question: how do you can replace the functionality of the "??" operator in old versions of Power Query?
@malchicken Жыл бұрын
Excellent summary, thank you 😊. I most enjoyed seeing how to log errors. 👍🏽
@GoodlyChandeep Жыл бұрын
:)
@excel-in-g Жыл бұрын
As always.... Superb stuff by Chandeep!
@mrrafael161 Жыл бұрын
Hello everyone, With reference to the case 2. Expanding Coumns Dynamically Wouldn't it be easier and more efficient to capture the names of the columns by creating the below step ( after Grouped Rows ): = List.Union( List.Transform( #"Grouped Rows"[ All] , each Table.ColumnNames(_) ) ) ?
@joelabacherli1310 Жыл бұрын
Another brilliant video. Thank you so much for sharing this knowledge.
@GoodlyChandeep Жыл бұрын
Glad it was helpful :)
@Tattysnuc Жыл бұрын
"Just eat the mango and you're going to enjoy". Love it. Top tips. Thank you!
@arbazahmad7177 Жыл бұрын
Excellent... Hack 1 case insensitive is great 👍
@christianmarpert3844 Жыл бұрын
really nice video! my favourite is also the dynamic column names one. do you know if you can create your own library bundling all the custom function, to easily include it into each project instead of copiing over? a while ago i was researching on that, but couldn't find anything...
@unnikrishnansanthosh Жыл бұрын
excellent one, thank you for sharing
@karinamatvejeva3164 Жыл бұрын
🔥🔥🔥 I like how You explain, thank You!
@surajbhardwaj428 Жыл бұрын
Hi Brother...✋ But how can I know the which formula will use for which purpose ...
@IamLillerz5 ай бұрын
Thank you so much! 👍
@sujit3375 Жыл бұрын
I am highly interested in joining your course But one question goodly Is that power query courses update with such awesome content time to time Or it remains static as content list given
@prasaddongare5779 Жыл бұрын
Hi, how to select chart's x-axis, y-axis, legends and values? how to differ them? what are the basic criteria's for choosing them?
@mattnyman99333 ай бұрын
Is there a way to go from type "Any" to type "Date" skipping the type "DateTime" when there is a time in the data?
@sanumpzha Жыл бұрын
This is cool stuff, loved it😍
@prashantsuthar7 Жыл бұрын
It works for me thanks
@sayi77 Жыл бұрын
What an amazing man you are.
@GoodlyChandeep Жыл бұрын
What an amazing comment 😍
@txreal2 Жыл бұрын
ChangedTypeNoErrors 👍
@RakeshSaha1705 Жыл бұрын
I need one help with s curve. I am unable to restrict the actual line chart to a certain date. The columns are date, product, amount, planned value, actual value. Product column has different products. Date column contains date till dec 23. Actual value column contains value till July 23. Planning value contains value till dec 23. Using running total measure for cumulative planning value is working fine. But the same measure for cumulative actual is showing value even after July 23. If possible make one video to restrict cumulative actual to a certain date.
@Rice0987 Жыл бұрын
3:57 you've added bubble sound to your transition.😂👍
@GoodlyChandeep Жыл бұрын
😉
@shoaibrehman9988 Жыл бұрын
Hi Chandeep could you pls assist me.  (POWER QUERY FROM OFFICE 365)Access Permissions Required to open queries from power query connections. Can i protect my queries to view
@ymohamed3154 Жыл бұрын
Thanks❤
@Rice0987 Жыл бұрын
2:34 i just remove that hard coded text, leave column name only.🤔
@sambazonatl Жыл бұрын
“Just eat the mango.” Brilliant.
@GoodlyChandeep Жыл бұрын
😂
@KhajonsakLun Жыл бұрын
Thank you very much for useful tricks. \^^/
@GoodlyChandeep Жыл бұрын
You're very welcome!
@Acheiropoietos2 ай бұрын
Intellisense did not work because it works best between 2 spaces, not touching another character.
@minadev16 ай бұрын
All went too quick for me, who I can get my head around this topic
@mohitshyngle82009 ай бұрын
While Expanding Column Dynamically, Post the expanding, I wish to add a coulmn of SUM, Sum of Collist, it gives error, Please help
@chrism9037 Жыл бұрын
The columns headings hack was brilliant, thanks Chandeep!
@sandipansarkar92119 ай бұрын
Finished watching
@devo098 Жыл бұрын
When all the data is flat and the same type, instead of manually changing each column type, you can unpivot the data from the date column. This gives the ability to. Change all the values to whatever type you need. Then pivot again. No hard coded names.
@DeronHuskey Жыл бұрын
Good stuff, especially the column expansion/transformation. I've got your ChangeTypeNoError video in my saved list. That looks like it could provide a LOT of utility. Thanks.
@DinoDelight5 ай бұрын
I love that errors one, the amount of times I have to say to colleagues..."you got dodgy data"
@Dan_De_Man Жыл бұрын
Nice tips! When adding the index step, shouldnt you change it to start from 2(or wherever your data starts) so that it will actually show the row number of the error in source file.
@mohammedelsakally540 Жыл бұрын
Thank you Chandeep for this informative video ...
@mirrrvelll51649 ай бұрын
Pure gold of tricks. thanks man
@baskis69 Жыл бұрын
Amazing tricks¡¡¡¡ Thanks for sharing
@dilipinamdarpatil6301 Жыл бұрын
Very useful..... Thanks 🙏🏼..
@damionc Жыл бұрын
You never cease to amaze. I was already doing number 1 but number 2 is a very nice trick. #3 is even better. I am writing this before I even finish watching.
@GoodlyChandeep Жыл бұрын
:)
@taizoondean689 Жыл бұрын
Superb 😊
@telclissonperes Жыл бұрын
Amazing!
@emilmubarakshin49 Жыл бұрын
This is bananas - especially the trick #5
@GoodlyChandeep Жыл бұрын
😂
@vikashparihar8366 Жыл бұрын
Hi I have 1 issue with POWER BI, (basically related to managing one to many relationship with dates, user relationship dax is not a scalable option for me here.) pls can you share mail id or any other place where I can describe the problem i am getting with my project.
@alexrosen8762 Жыл бұрын
Fantastic tutorial, especially the capturing errors part