Check out our newly launched M Language course ↗ - goodly.co.in/learn-m-powerquery/
@antoniojosemoraesdoprado2042
10 ай бұрын
You are always very good at addressing the issues straight to their points in a very clear way.
@jenniferpavey1
6 ай бұрын
Oh my word I’m blown away - so efficient compared to how I was accomplishing this before
@brianjulius6401
2 жыл бұрын
Crystal clear explanation and great additional recommended resources. Thanks, Chandeep!
@syrophenikan
2 жыл бұрын
Here's an alternative function to determine the embedded error message: = Table.AddColumn(Source, "NewPrice", each try [Price] catch(err) => if err[Message.Parameters]{0} = "#DIV/0!" then 10 else if err[Message.Parameters]{0} = "#N/A" then 5 else 0)
@fdoublef2008
2 жыл бұрын
Helpful video, thank for sharing. And I want to know what your screen record app? thank you!
@GrainneDuggan_Excel
2 жыл бұрын
Thanks Chandeep for the clear explanation of try catch and the link to the MS documentation for it!
@GoodlyChandeep
2 жыл бұрын
Glad you like it! 💚
@abhaydwiveddi3760
2 жыл бұрын
hi chandeep it is very helpful video.... one more thing I an struggling with the direct query these days can you please help me to solve this issue.... I am unable to do transformations and merging, filtering in power query.
@fahimreza1377
2 жыл бұрын
Being a newbi its a great lesson... Thanks mate!!
@GoodlyChandeep
2 жыл бұрын
Happy to help!
@cristian.angyal
2 жыл бұрын
Great video Chandeep! Didn’t know Message.Format and Message.Parameters made it to Excel 😜 Thanks for sharing!
@GoodlyChandeep
2 жыл бұрын
Glad you like it 💚
@dapperlink
2 жыл бұрын
Wow! Just WoW! I have a feeling there’s going to be more bennies coming out of this feature.
@paulgallagher2987
2 жыл бұрын
This is so helpful. Thank you Chandeep!
@GoodlyChandeep
2 жыл бұрын
Glad it was helpful 💚
@YouExcelTutorials
2 жыл бұрын
Very well explained👏 Thanks for sharing Chandeep!
@GoodlyChandeep
2 жыл бұрын
Glad you like it 💚
@shoaibrehman9988
2 жыл бұрын
It is awesome content. 👌 Sir if you can explain DAX bit advance level it will be good. I have raise one query from many power bi experts and Dax champ no one come back with appropriate solution. In future video could you pls explain running total by category and by month both together. Means in each month like Jan ,feb ....etc i can calculate running total of all orders of all products.
@krishnakishorepeddisetti4387
2 жыл бұрын
I like your content a lot.... most of these are not present in normal power bi trainings
@GoodlyChandeep
2 жыл бұрын
Glad you like the content 💚
@Gorman-84
6 ай бұрын
Nice job. Thanks.
@BORISVLEONOV
7 ай бұрын
You saved me!. Subscription.)
@cjimmer4877
2 жыл бұрын
Amazing. I love this!
@GoodlyChandeep
2 жыл бұрын
Glad you like it 💚
@martyc5674
2 жыл бұрын
Brilliant content as always Chandeep 👍👍👍👍👍👍
@GoodlyChandeep
2 жыл бұрын
Thank You 😊💚
@alexrosen8762
2 жыл бұрын
Wow! Great stuff thanks
@GoodlyChandeep
2 жыл бұрын
Glad you like 💚
@Rice0987
Жыл бұрын
A bit not exactly my topic, but as usually interesting, so thanks! :)
@GoodlyChandeep
Жыл бұрын
Glad you enjoyed it!
@Rice0987
Жыл бұрын
@@GoodlyChandeep your videos are always enjoy. :)
@krishanphophalia9303
Жыл бұрын
Awesome ❤
@frachiar4444
7 ай бұрын
I still use Excel 2016 ... maybe is this the reason why gives me sintax error?
@shikharai9378
4 ай бұрын
How i should do this for entire table instead of only one column?
@brunalima7145
Жыл бұрын
wow, that's very good, thanks ❤
@GoodlyChandeep
Жыл бұрын
Glad you like it Bruna!
@siddheshamrutkar8684
2 жыл бұрын
Superb.... 👍
@GoodlyChandeep
2 жыл бұрын
Thank you!
@shanestocks89
3 ай бұрын
Mine acts weird. When I use try I only get FALSE with a error in the window saying "DataFormat.Error Invalid Cell value "#N/A". I am seriously struggling to find this error, I have a table with a million rows and it stops the whole query. I cant even use a blanket remove error it still says dataformat.
@BrainyBrunetteBarbie
2 жыл бұрын
You always crack me up…”what the HELL is a try and a catch???”
@GoodlyChandeep
2 жыл бұрын
Haha..thanks! 💚
@BrainyBrunetteBarbie
2 жыл бұрын
@@GoodlyChandeep Of course! It’s nice to see someone else making excel puns and asking the *real* questions. Haha Any chance there’s a way to do find and replace in the advanced editor? Right now I’m copying / pasting the code into MSFT Word to edit, then pasting it back. Maybe it’s something that won’t be as much of an issue as my M Code improves.
@milindbhende3043
9 ай бұрын
How to catch "DB connection Time out" error in Power Query?
@krishnakishorepeddisetti4387
2 жыл бұрын
first like.. first comment...
@GoodlyChandeep
2 жыл бұрын
👑
@alirezahossini463
2 жыл бұрын
Because message error is unique you can use text.contains
@ziadelmokadem5452
Жыл бұрын
I am trying to use try otherwise and if then with two arguments, but it doesn't work (with two merges), any idea how to do two merges in the same step ? the argument =try Table.ExpandTableColumn(#"Merged Queries1", "Table1", {"A", "B"})otherwise Table.ExpandTableColumn(#"Merged Queries1", "Table3", {"A", "B"})
@MrDonkey912
Жыл бұрын
Hopefully youtube doesn't break the formatting. here's what you want = try Table.ExpandTableColumn(#"Merged Queries1", "Table1", {"A", "B"}) catch (e) => Table.ExpandTableColumn(#"Merged Queries1", "Table3", {"A", "B"}) try `otherwise` is the old format, you lose any potential error information, or that there even was an error.
Пікірлер: 49