Learn Power Query in just 45 mins | Power BI | Must Watch

[@learnwidgiggs]

Link to download the sample files for practice is there in description box. Please feel free to use it.

[@ganeshreddymotakatla6244]

@LearnWidGiggs Hi Bro, Thanks for your clear videos on interviews...I hve cleared my interview @PWC..thanks. Hope we can meet over in PWC communities/ teams

[@learnwidgiggs]

@@ganeshreddymotakatla6244 Glad to hear this news!

[@ganeshreddymotakatla6244]

@@learnwidgiggs 👍

[@sainathguthula981]

that link can not be dowland @learnwidgiggs

[@subhranilmajumder2938]

U have changed the data type in customer3 instead of customer1 to show refference,although the explanation is pretty good to understand. Please watch it from 5:01 time of this video for better understanding.

[@learnwidgiggs]

Okay, thanks for pointing it out

[@RaMeShBaBu-gf1wc]

This is the best video of power query transformation

[@learnwidgiggs]

Thank you..share it with your friends too 🙂

[@priyankathakur1691]

Thank u for creating such clean videos on Power Query, which is easily understood. Keep posting such informative videos on PBI projects as well.

[@learnwidgiggs]

Thank you, I will

[@vaibhavitatekar4700]

Thank you for making this video on Power Query and explaining it in the most easiest way.

[@sanyarastogi9205]

Thank you so much Sir for this informative video. Learned a lot about different transformations used in Power Query and practiced alongside. Keep sharing such videos.

[@learnwidgiggs]

You are most welcome!

[@hairavyadav6579]

Best video to learn any thing in easy way

[@jaypandey4101]

Great video, right to the important points. Please do upload mores stuff like this. Thank you.

[@learnwidgiggs]

Welcome 🙂

[@srinuguntaka4341]

This content is very useful to us ,thanks a lot.

[@learnwidgiggs]

Glad to hear that!

[@srinuguntaka4341]

@@learnwidgiggs Can you please do the complete DAX tutorial ASAP.

[@jagadishreddy9140]

Thanks for your efforts and for making this video. Very Informative Video this is.

[@learnwidgiggs]

Welcome 🙂

[@venkatasireeshamarella5677]

Really very good and informative vedio with clear explanation nd less time 🤩 .... Thank you 😊

[@learnwidgiggs]

Most welcome 😊

[@sambhajizambre9650]

thanks for making this video .Nice explanation and all things really needful

[@learnwidgiggs]

Glad it was helpful!

[@sushantmeshram5172]

Thank you so much. I feel more confident now.

[@Shinde9755]

Hi Shashank. Thank you so much video of Power Query. Its Easy to understand

[@sreemalapal]

Super helpful video...Great explanation!!

[@learnwidgiggs]

Glad you think so!

[@mukulraj6184]

Thank you so much for the informative video. Well explained 👍👍

[@learnwidgiggs]

Glad it was helpful!

[@perfectionist6624]

Hi sir, Can u plz make full video on where to use Calculated columns in & when to use Measures in real projects. Like give examples where we need mandatorily required to create Calc column in model and measures examples which can replace creating Calclated columns. Plz make this with one example for each to clear understanding. Thanks in advance.

[@raghibelahi937]

Thank you so much for explaining complex queries and transformations with ease..Great👏

[@learnwidgiggs]

My pleasure 😊

[@tinnymanmeet]

Good and quick explanation.

[@learnwidgiggs]

Thank you 🙂

[@sandeepghatge7859]

It will help us a lot. Thank you

[@learnwidgiggs]

Welcome 🙂

[@rupeshsurve6088]

Great video and good explanation. Thanks for your efforts.

[@learnwidgiggs]

Welcome 🙂

[@munikumarpoosala1264]

really nice video ...keep rocking

[@deepmathur6390]

informative video brother..... thanks for your efforts

[@learnwidgiggs]

Welcome 🙂

[@praveenkumar_9143]

Covered important topics and practiced along with you!! Very Useful video

[@learnwidgiggs]

Glad it was helpful!

[@GAMERX-vk6fc]

bhai you earned a subscriber. thanks a lot for this video.

[@rajeshmanepalli7367]

More than enough shashank

[@manjupreetham]

Thank you so much your explanation is nice 👌

[@learnwidgiggs]

Thank you 🙂

[@Aestheticdeeps]

thank you soo much sir clearly explained😇

[@learnwidgiggs]

Most welcome 😊

[@sanket565]

Really helpful video 👌

[@learnwidgiggs]

Thank you 🙂

[@Lakshvedhi]

Very very helpful, thank you

[@ravitejadatta7862]

simply superb sir

[@learnwidgiggs]

Thank you 🙂

[@rajatdixit11]

Very informative video 😊🙏

[@learnwidgiggs]

Thank you rajat 🙂

[@ajaykumar-ye8cv]

Thanks for your efforts and it is very useful

[@learnwidgiggs]

Welcome 🙂

[@krishnamagdum6496]

Very helpfull sir...thanks

[@learnwidgiggs]

Welcome 🙂

[@AkankshaSingh-mg1vr]

Great video indeed, learning many new things 👍🏻

[@learnwidgiggs]

Welcome 🙂

[@mahfoudhcheikhna2754]

Excellent video

[@divyachamakuri769]

Excellent ❤️

[@learnwidgiggs]

Thank you 🙂

[@divyachamakuri769]

@@learnwidgiggs can you make videos on pivot, view, services aswell

[@nishthatank5954]

Great content sir

[@learnwidgiggs]

Thank you 😊

[@gopichand-q8k]

grate thank you 👏👏👏👏👏

[@santoshwaghmare4081]

Please bring the advanced transformation video of part 2🙏

[@learnwidgiggs]

Will plan 👍

[@vaijayantigulve4883]

very useful content. But kindly zoom-in your screen or increase the font size. Thank you.

[@learnwidgiggs]

Sure, thanks for the feedback

[@GopikrishnaNallapuneni]

Can you create entire series on Power BI development

[@sanket565]

I have a querry. If we create a reference table and then make changes to master table..but disable load. Will our reference table be affected?

[@learnwidgiggs]

I think it will be affected because disable load would come into effect once we do close n apply..not before that.

[@KaleemUllah-qi7hf]

I learnt many things

[@enjystory464]

Sir if data is in sales then same customer buys 2 time ,1st time phone and 2nd time earphone so then we have to delete the duplicates?

[@learnwidgiggs]

No, why will you delete

[@enjystory464]

@@learnwidgiggs u said in video that first trim the data and delete the duplicates these are must do when you r working in power bi like that u said sir

[@SandyRwt-n6d]

Sir please make one shot video on dax function

[@meghab2910]

What is the difference between Left join and left anti?

[@learnwidgiggs]

Left join - All the matching records + Left records in left table Left Anti - All the non-matching records in the left table

[@aparnavenkataraaman8804]

Hi Sir, i got an interview question on calculated columns. I am in beginner level. Hence i am asking such question. We have table with one column and column consists of 1 lakh rows with numbers. Interviewer asked me to display odd and even numbers form that column. Can you please explain me how to do that

[@learnwidgiggs]

Use Conditional column feature

[@krisy8434]

in Merge if there are no common columns to join, then ?

[@learnwidgiggs]

Then you can't merge.

[@krisy8434]

@@learnwidgiggs okay but can we do it with custom column

[@learnwidgiggs]

@@krisy8434 yess if you somehow create one.

[@perfectionist6624]

Thanks sir ❤

[@learnwidgiggs]

Welcome 🙂

[@ManoSru]

Boss of PBI

[@bhargavibharu5883]

Hi I am from Non It background I. Have learned power bi and SQL. can I get job on powerbi as fresher.. how can I approach the companies who take me as a fresher..

[@learnwidgiggs]

Yes you can get the job as a fresher. You need to apply extra efforts than other people, you have to make online presence on linkedin.

[@learnwidgiggs]

If want to discuss things in detail, then plz book 1:1 session on Topmate.(link in About section of the channel)

[@shivangisrivastav3336]

Best❤

[@Nani-et7gk]

Hi, I'm not able to view/open the .rar sample file from drive. Can you please advise how to do ? Thanks!

[@learnwidgiggs]

Download and then right click extract it.

[@syedmohammedidris5605]

Super

[@learnwidgiggs]

Thanks 😊

[@SanthoshkumarSenthilmurugan]

Absolute basics

[@danielessiet4063]

Do you have a personal website?

[@learnwidgiggs]

Not yet!

[@gsreenivasulu3246]

Please provide the dataset that will be help full, other wise it doesn't make sense

[@learnwidgiggs]

The link to download the sample files is there in description box. Please use it for practice.

[@perfectionist6624]

Hi sir can u plz make similar type of full video for Data Modelling In Power BI...

[@learnwidgiggs]

Will do a video on this soon.

[@Peaceful_World130]

Thanks sir

[@learnwidgiggs]

Welcome 🙂

[@ReshmaShaik-vt4wb]

Thank you sir

[@learnwidgiggs]

Welcome

[@LakshmiNarayana-rm4oq]

Can you do video on power pivot module

[@learnwidgiggs]

ok, I will do a video soon.

[@avinashsomesula4166]

thank you

[@learnwidgiggs]

Welcome 🙂

[@NitinSharma-sr5rn]

Its only basic in power query not advance

[@vikkyghale4311]

do i need to be an expert in power query M?

[@learnwidgiggs]

No, basic understanding would also work.

[@shilpishukla8706]

thanks

[@minadev1]

I can not download the videos

[@perfectionist6624]

Please provide sample dataset

[@learnwidgiggs]

The link to download the sample files is there in description box. Please use it for practice.

[@perfectionist6624]

@@learnwidgiggs thanks

[@vjyrml]

Try to work on larger data, the data you taken is very few rows

[@learnwidgiggs]

noted, thank you

[@lakshmipriyachandra5604]

Found the best video for beginner stage thank you @learnwidgiggs

[@learnwidgiggs]

Glad to hear this!

[@anupmishra154]

Hi sir, Can u plz make full video on where to use Calculated columns in & when to use Measures in real projects. Like give examples where we need mandatorily required to create Calc column in model and measures examples which can replace creating Calclated columns. Plz make this with one example for each to clear understanding. Thanks in advance.

[@learnwidgiggs]

Noted

[@syedmohammedidris5605]

Super

[@SaiKumar-eo1ql]

Thanks sir

[@learnwidgiggs]

Welcome 🙂