IFERROR in Power Query - try and otherwise

[@niharikamedam]

Today i faced this problem in one of the report then got this video, it helps to remove the columns dynamically which are deleted in sharepoint Thanks alot :)

[@GrainneDuggan_Excel]

Marvelous! I used try/otherwise for row level issues. The moving steps solution and the error documentation ideas will be very helpful. Looking forward to part 2 of this video

[@vacilando86]

Wow, that was shoked me when I see detailed information about error. Thank you so much

[@bendreessen2809]

Another great video! thank you for sharing this. I was able to retrieve the PO description after changing the type to a whole number. Thank you for sharing your knowledge!!

[@aatsw]

Brilliant. This channel is underrated.

[@CeliaAlvesSolveExcel]

This is great! I have used try/otherwise but technique on example 3 is new to me and it may be of great help in some scenarios. Thank you for sharing. :)

[@GoodlyChandeep]

Hey Celia, glad to see you here! I learnt this trick from the MS Documentation and Reza's Blog

[@deronde74]

good explanation with full context. Great vid!

[@williamarthur4801]

Thank you, I've avoided 'try' as didn't really know what it was and thought of it as 'if' not "if error', so thank you for clearing that up right at the start, why can't MS DOCS tell you this stuff? Quote 'A try expression converts values and errors into a record value that indicates whether the try expression handled an error', which yes does now make sense.

[@skimpylemon8034]

How do you only have 30k subscribers? Your videos are excellent man! Keep it up, I hope you blow up soon on this platform! 😊

[@GoodlyChandeep]

Thank you for the inspiring words! 💚

[@wayneedmondson1065]

Hi Chandeep. Awesome lesson! Was not aware of the error details you showed in example #3. Thanks for sharing this and the articles :)) Thumbs up!!

[@alexrosen8762]

Very useful tutorial. Thanks!

[@GoodlyChandeep]

Glad it was useful 💚

[@singhbxut]

You are good. Thanks for all the tips

[@GoodlyChandeep]

Glad you liked them!

[@nagnathrudrawar5278]

My company close books on every Circle Sunday. Some times 30th Nov counted in Dec month. So I Create Manualy month column in my data. How I can create calander in power BI with this issue ?

[@felipesignorellireis7839]

Very good. Cheers Brazil.

[@aynino]

Masterclass. Thanks for sharing

[@GoodlyChandeep]

Glad you like it!

[@ronc390]

I'm a Rookie - Thsi helps so much. Can you suggest how to replace a NaN error with 0?

[@weav8060]

Did you ever do the sophisticated video? I have a sophisticated error where I have to find. And eliminate any columns among 100+ that is full of errors. So I have to count the errors in each column and eliminate the col with many. I think I need try within a list.transform applied to each column , but this all has to be done efficiently

[@GoodlyChandeep]

this might help kzbin.info/www/bejne/f3jclXafnNCqf5Y

[@norpriest521]

Thank your sir. Have you ever come across Expression.Error we cannot convert value 0 to type Text? I tried to fix it for many days but still had no idea what the problem was. It occurred when I tried to Close and Load after I merged the 2nd table to my main table. Thank you

[@ajieapen]

Could you provide the links to the 2 articles you mentioned, please?

[@GoodlyChandeep]

Just added that in the description

[@ajieapen]

@@GoodlyChandeep Thank you... :)

[@anuragbawankar685]

Thanks Sir ! Air if Table should display values greater than the value selected in filter slicer Let series be 1,2,3,4,5,7,9,10,20etc If we select 5 in slicer , table should display 7, 9,10,20 etc How can I achieve that sir?

[@BrainyBrunetteBarbie]

This is so cool!!

[@GoodlyChandeep]

Thank you 💚

[@FRANKWHITE1996]

I see here some advanced magic spells 😉 🙌🙌🙌

[@darryl2237]

u saved me again!!

[@GoodlyChandeep]

Thank You!

[@SMITDEDHIA96]

😮😯😲