Power Pivot RELATED Function | Vlookup Replacement | Relationship and Import Folder Data

Power Pivot RELATED Function | Vlookup Replacement | Relationship and Import Folder Data using power query
Excel Power Pivot Playlist Link- • Excel Power Pivot
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#powerpivot #tablerelationship#innozant #exceltutorial

[@deepraazshaw7369]

Sir apke jaisa KZbin me Hindi me koi nji sikhata. Thanks you sir aap hamre life me value add kr rahe hai.

[@Innozant]

Thanks Deepraz aapke valuable feedback jke liye..eham hain ye words mere liye yadi apki life me main value add kar paya whi merA fees hoga

[@deepraazshaw7369]

Sir Mai apke vidoe ko mere Sare frnd ko share Kiya hu. App bahut hi a6a sikhate hai teacher jaisa.

[@Innozant]

Haan unsabse boliye jaise maine playlist wise upload kar ra hu video..in sequence seekhna hai unhe..

[@AvinashKumar-vm1if]

Aapka video mere life me bhot value Add kr rha h sir..... Logo ko Successful people ya Bollywood celebrities se milne ka Sapna hoga....lekin mujhe aapse milne ka h....Ek din Jarur milunga sir...Naam yaad rakh lijiye.....You are my inspirational man...Once again Thank you...Pranam

[@Innozant]

Thanks Avinash Ji..Itne valuable comment ke liye..Ye videos aapke lif eme value add kar paa rahe hain ye mere liye bht badi baat hai .Step by step seekhiye aur life me khud ko ek step aage dekhna hai humesha

[@Uniqueshreee]

There is no such word as of now for you, I think you are the Unique Excel Guru.

[@Innozant]

Really means a lot to be

[@saddammalik5566]

You've been very helpful and alongside you are also best friend for us.👍

[@Innozant]

Thanks Saddam..Happy Learning dear..God bless you👍❤️

[@jaitiwari241]

True

[@AvinashKumar-vm1if]

Superbb...Sir ,Aapke video se Life me Value add hota h .... Thank you

[@Innozant]

Thanks Avinash..Love you dear🙏❤️God bless you all.

[@akshatgoyal2473]

Thank you so much for starting again series on Power pivot Eagerly waiting for the next chapter

[@Innozant]

Thanks Akshat Ji..Happy Learning dear..God bless you 👍❤️

[@neerajkhurrana283]

Sir, I bow to you with respect. You are the best thing that has happened in my life ❤😊

[@Innozant]

Thanks dear

[@sudiptamanna4195]

Your taliking style like Hrithik Roshan... keep it up great video sir

[@Innozant]

😊 Thanks Sudipta ...Happy Learning dear👍❤️🙏

[@vishalbhati912]

Bahot badiya sir. Ye hi sikhna tha mujhe. Plzzz video banate rahna ispe. Thank so much. Aapke channel ko subscribe karke mujhe kai chize janne ko mili he. 🙏🙏🙏🙏

[@Innozant]

Thanks ❤️❤️Good Night

[@mdsahabajansari6002]

please be consistent ......what do you think people wait for six months to learn new concept.....eventually they try to learn from other resources......maintain a schedule .........you explain concepts very easily .waiting for next video

[@Innozant]

Dear Sahabaj kindly note that i am runny number of Playlist parallel and uploading videos on regular basis.Yes Power pivot videos was not uploaded as fucused on Power Query Series.Thanks for your suggestions 🙏❤️

[@deepraazshaw7369]

Sir very very thankyou for this video. Mujhe Kafi Dino se intajar tha. Thanks you sir.

[@Innozant]

Thanks Deepraaz

[@jaitiwari241]

Best part sir you also share dataset to practice and dive deep into each topic

[@artiverma2357]

we all time respect you guru g , because of you i learn excel breifly

[@Innozant]

Thanks Arti Verma Ji...God bless you dear❤️🙏

[@sudhashy0]

Extraordinary way of explaining.

[@Innozant]

Thanks Sudha...Good Night ❤️

[@sudhashy0]

@@Innozant Good Night Sir. Ram Ram 🙏

[@bholasinghverma2412]

Good evening sir, I am Bhola Singh Verma Mai apka pura video dekhta hu aap basic se lekar advance Tak clear jankari dete ho Mai apna computer me excel file formula put Kiya hu lekin us excel file ko kisi dusare computer me use karne se formula Kam na kare taki excel file ka formula safe rahe. Sir aapse request hai ki aap upay bataye

[@Innozant]

Formula hide kar diya karen...security topic me cover kiya gya hai video me

[@rajdeepsaha9059]

Great Interpretation

[@Innozant]

Thanks Rajdeep

[@faisalmd283]

Thanks for resuming the most awaited power pivot series. All thanks from bottom of my heart😊.

[@Innozant]

Thanks Faisaal sahab.Happy Learning.. Thanks for your love and support

[@ArunKumar-jh4qe]

Sir plz start Power Bi vedios also. Your presentation skills are superb. Thanks sir

[@Innozant]

Thanks Arun,Sure dear will start Power BI series soon.

[@prabalroybarman5466]

Have seen basic playlist what playlist should I watch next ..and also could you upload count and counta, count if advanced stuffs and also how to combine one function within another and what is the concept

[@Rajvlogs4401]

Views nahi aa rhe par video most satisfying hai ❤

[@Innozant]

Thanks dear

[@gulshanmehta6997]

Thanks Sir, for sharing very informative tutorial 🙏🙏🙏

[@Innozant]

Thanks Mehta Ji👍❤️

[@Ashish-ie5di]

Informative video

[@satishojha6240]

Sql mai dekha hai aise but aap ka explanation bahut hatkey hai 🙏🙏🙏🙏. good night sir.

[@Innozant]

Thanks Satish Ji .Ab Power Query ,Power Pivot aur bht jald Power BI ke video bhi aane wale hain..seekhiye aur badhiye life me aage

[@satishojha6240]

@@Innozant I really excited sir 🙏🙏🙏

[@altafmanjothi5180]

Hello Sir, Very Helpful Video but can we use pivot table when we dont have unique Values (Can we use many to many relationship here) In power bi I used but in pivot table how can we use? Please explain

[@VimalKumar-ih6ik]

Great Learning

[@jayantabhattacharyya628]

Dear Sir Thanks for resuming the magic of power pivot again. Your way of teaching makes the topic easier for me. Many more exciting functions such as DAX, Measure are yet to come. I am eagerly waiting for that. Sir, does excel 365 have power query add-ins facility? Thanks & Regards Jayanta Bhattacharyya

[@Innozant]

Yes Jayanta.. Thanks dear❤️🙏

[@iveymbabest5303]

Awesome video

[@shrikantbadge3978]

Amazing sir. Thank you.

[@mohammedshamim9568]

Love to hug 🤗 you brother ❤

[@hemantsingh9966]

Great Sir

[@TheSuvankarKundu]

Boss.. you are exceeding our expectations 🙏

[@Innozant]

Thanks Suvankar .Love you dear ..👍🙏God bless you

[@dhakafady774]

thanks a lot, sir for the wonderful content

[@Innozant]

Thanks dear

[@prajwalshetty2047]

Sir I used separate Power query to append Gross sales of various Branches to find total Gross sales and Sales return of various Branches to find total sales return in two different sheet, in one sheet total Gross sales and in other sheet total sales return. To find Total Net sales, I manually reduce sales return from gross sales. Sir is there any way to do this all calculation in power query itself.

[@prabalroybarman5466]

Hi have seen the basic excel playlist so where is the advanced Excel playlist or which playlist should I watch after basic excel playlist and also in one video you said about interview question counta and count func and you said later on you will be uploading advanced stuffs on this first learn the basic concept

[@Innozant]

Watch this video mis Learning process kzbin.info/www/bejne/aGqWZmhmar1mr7c

[@AvinashKumar-vm1if]

Aap ye sab kaise jaante h sir.... Kon Book se aap itna Knowledge gain kiye h

[@Innozant]

Life me gheeshte 😀hain jo log unhe book ko refer ki jarurat nhi hoti hai .. situation sab seekha deta hai jab apke paas koi dusra option nhi rheta hai aur focused hote hain life me to

[@SaurabhSharma-ry8iz]

AWESOME SIR

[@Innozant]

Thanks Saurabh 🙏❤️

[@ankitjindaljulana]

Thank you sir

[@Innozant]

Thanks Ankit ji

[@vgug707]

Hi, can you suggest few student good in excel, we can provide good job

[@Innozant]

Hi,You may Connect With Innozant Consultancy and share your JD with our Team.

[@rohanparakhe4976]

Please make video on difference between data analysis and business analyst

[@Innozant]

Career guide playlis me jaake last video dekhiye.. complete explain kya hai..👍❤️

[@createyour6681]

Very great sir

[@Innozant]

❤️🙏

[@kishorpanara4191]

Sir bahot achha jaga lekin pura samaj me nahi aya kyo ki mere liye thoda advance hai thank you sirji

[@Innozant]

Pehle excel finish kijiye jab aapka pivot table finish ho jaye uske baad power query aur power pivot seekhna hai dear Kishor

[@kishorpanara4191]

@@Innozant ji sirji ye video dekha aur like kiya

[@tejpalsain1507]

Thanks

[@Innozant]

Thanks Tejpal❤️🙏

[@manojkumarsingh3385]

Nice sir ji

[@Innozant]

Thanks

[@artiverma2357]

wow sir padtey kha se hai ap ,muje bhi pilao ye jaadu ki guuti

[@Innozant]

Hahahaha...Ye jaadu ki guuti apke paas bhi hai bus regular learning krte rhiye ek waqt aane par apko bhi ofc me kahenge mujhe bhi de do ye guutti jaadoo wali

[@abhisheksable4592]

Hello @innozant please show your screen in full size

[@ViveganVibes]

Hello Sir I'm a librarian I need your help to creat a library issue return of books please help me.

[@Innozant]

Hi Narmada..Kindly share your query @innozantofficial telegram id..Will guide you for the same.

[@rakeshmlearningentertainme6099]

aswesome video

[@RahulRoy-po9ct]

🙏

[@sudeshjadhav8838]

Sir ji main payments slip bana raha hun our us main uppar ka column merge hai wapas char line chhodkar niche ka column bhi merge hai to autofit ho sakta hai kya

[@Innozant]

Sheet dikha payenge to sure help kar paunga..@innozantofficial telegram id

[@sudeshjadhav8838]

@@Innozant bilkul sir. thanks sir apke sub videos achhe hai. Aap bahut hi asanise aur aur bahutsi chhoti chhoti chij samjate hai thnks. Is me photo copy bhej sakte hai kya.

[@sudeshjadhav8838]

Dusra koyi option hai telegram nahi use karta hun

[@dancertrishika]

Dear sir thanks, but can you make a video for this.

[@Innozant]

Noted

[@durgeshrai8938]

Nyc sir

[@Innozant]

Thanks

[@HEMALSINHPADHIYAR-n2m]

many to many relationships do not currently support worksheet

[@TheVaibhavdang]

what is the folder name in the drive for evening,general,morning txt data ?

[@Innozant]

It is Ava under pivot table playlist

[@TheVaibhavdang]

Ok I will check it

[@abdullahalmasud302]

Sir, Could not find the data folder(morning , evening ,night data file)

[@Innozant]

It is there inside folder .kindly check link in video description

[@jyotikashyap7733]

Sir, Power pivot add download kha se karna h pls share the link if possible.

[@Innozant]

Jyoti ..Which version of office you are using..? Download it from Microsoft site

[@jyotikashyap7733]

@@Innozant Sir, I using Excel 2013, i have downloaded power query as per u r suggestion but i can't download power pivot from add-ins and also not showing my add-in into Excel. 2013 which I m using 2013.

[@MonirulIslam-fw5zf]

Salam sir. Apka practice file download nehi ho rahi hai. kindly practice mil jata toh or bhi ahsan hota practice karne me..😀😀

[@Innozant]

Direct link broken hai but assignment master folder link diya gaya hai wahan se download kar lein playlist excercise

[@Ann_2208]

Sir itna kafi hai Power pivot ya or bhi syllabus hai isme

[@Innozant]

Abhi hai syllabus.wo humlog aage power bi series me cover kar lenge jald

[@HEMALSINHPADHIYAR-n2m]

many relationships do not support

[@PradeepKumar-tl7dd]

price*quantity does not match

[@asifinam3948]

Sari game hi relationship ki ha 🤣

[@shrikantbadge3978]

apne to muze is data me female bana diya sir 😂

[@Innozant]

Hahahaha..Kaise ?❤️

[@shrikantbadge3978]

@@Innozant mere name k aage gender female likha hain 😄

[@Frooti-l8w]

Thanks a lot

[@mdrohanislam7503]

Sir apko contact kar sakte he plz 🙏🙏

[@Innozant]

Visit innozant website