Dynamic Pivot Table with Multiple Tables using Power Query

Рет қаралды 27,274

3 жыл бұрын

#PivotTable #PowerQuery
Hello Friends,
In this video, You will learn how to create Dynamic Pivot Table with Multiple Tables using Power Query. We have taken 4 different yearly Sales Table and one Employee Master Table. We have used Power Query to Consolidate the data and display in final Pivot Table Report with Slicers and Sparklines.
Download the practice files from below given link:
www.pk-anexcelexpert.com/dyna...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

Пікірлер: 52

@nsanch0181 3 жыл бұрын

I really enjoyed the video PK. Thank you. It was fun using the Power Query, merge function and Sparkline's.

@tariqanwar3518 3 жыл бұрын

You are such a wonderful instructor. Clear, concise and crisp. Thank you.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@karimsamnani3660 Жыл бұрын

Excellent explained Power Query along with 3 D Table

@PKAnExcelExpert Жыл бұрын

Thanks for liking

@KrishnaKumar-zn9kg 3 жыл бұрын

You have a wonderful and simple way of explaining the topics. Hats off to you.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@santiiceabs3869 3 жыл бұрын

Thank you much for this wonderful knowledge.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@carlosrobertomartinezandra9120 3 жыл бұрын

Excellent, power query is the best ... together with all the graphics that you show us, hopefully and you can show us the relationship between power query, power pivot and power view, it would be the best video between data transaction and high impact graphics ... thanks greetings from Lima, Peru

@kofi-tawiahagyeman 3 жыл бұрын

Hello PK. Keep up the good deeds. You've been very helpful.

@rajsahu1029 3 жыл бұрын

I have seen your videos in I-Pad. Today, I have seen seen /visit your wave-site, I found that very very useful things are available. Very honestly, I am tailing that I am seeing your videos as my hobby. I found that your information in charts are represented in very very beautiful manner. But, I am not know vba. However, If I try then , I may learn VBA also. Your videos are also available. I am seeing in Hindi videos of Abhimanyu Bhardwaj, Dipak Nehra, Satish Dhanwale but when I listening your videos your lecture is very clear. I also viewing Leela Gharani. You are doing very good work. I hope that your subscriber base may increases.

@rajeevhirlekar3746 3 жыл бұрын

Sir Thanks you very much.. such wonderful tutorials.. I always learning from your videos...👍

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@amirsaiftaz 3 жыл бұрын

Great Sir, always teaching new techniques. Amir

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@bapumote8921 3 жыл бұрын

Very nice video & very useful information.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@khalidmajeed2886 3 жыл бұрын

great--------------------------------more videos require

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@MrDhunpagla 3 жыл бұрын

Enjoyed & loved a lot . Thanks for this, please make a comparison report like this with PQ Sir 🙏👍

@sulemanismail3061 3 жыл бұрын

Sir this is very good but I have no other words to praise Thank U so much Thank

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@sulemanismail3061 3 жыл бұрын

@@PKAnExcelExpert your nice sir

@jasonbersabe8811 2 жыл бұрын

you are amazing

@Luciano_mp 3 жыл бұрын

Good, very useful. Thank you...👏

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@anilkakade5793 3 жыл бұрын

Your Great Sir

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@jgun0075 3 жыл бұрын

Always U are Awesome 😎

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@shoryaarora1464 3 жыл бұрын

It's amazing 👏

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@inderr7bajaj 3 жыл бұрын

Great yaar...👍🏻

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@saurabh17sharma68 3 жыл бұрын

Sir great video

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@rajsahu1029 3 жыл бұрын

Thanks

@PKAnExcelExpert 3 жыл бұрын

Most welcome

@samyraad5258 3 жыл бұрын

Nice knowledge PK, can you show us how to create liquor and beer keg calculator 🙏🙏. Thank you

@karthickudt9 3 жыл бұрын

Nice 👍

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@sakhtaronline2809 3 жыл бұрын

Can we set emails with custom filter to get Google Forms data entered by users via Google Forma

@bikassingh7469 3 жыл бұрын

How to combine different set of data with sane dimension names example, salaries and bonus

@bharatpokhriyal7185 3 жыл бұрын

Hello sir pls google sheet pe Dashboard ki video banao

@saurabh17sharma68 3 жыл бұрын

Sir this can be work on office 2007? plz reply sir

@santanugupta6446 3 жыл бұрын

Dear sir, how to jump on "Name Box" without mouse

@PKAnExcelExpert 3 жыл бұрын

Alt+M+N

@kofi-tawiahagyeman 3 жыл бұрын

PK can i have your email to discuss something with you?