![Abhay Gadiya](/img/default-banner.jpg)
- Видео 266
- Просмотров 347 309
Abhay Gadiya
Индия
Добавлен 16 июн 2011
Videos related Excel and other software
Interactive Chart with slicer displaying highest and lowest sales month new #exceltricks #charts
Interactive Chart with slicer displaying highest and lowest sales month new #exceltricks #charts
Просмотров: 176
Видео
Long Term Capital Gain on shares purchased before Jan 31, 2018 #ltcg #capitalgaintax #capitalgain
Просмотров 35814 дней назад
Long Term Capital Gain on shares purchased before Jan 31, 2018 #ltcg #capitalgaintax #capitalgain
Totals inside Pivot Tables are incorrect how to resolve it.
Просмотров 10321 день назад
Totals inside Pivot Tables are incorrect how to resolve it.
How to do approximate Match inside Power Query
Просмотров 105Месяц назад
How to do approximate Match inside Power Query
Getting Serial number starting 1 to 1000 instantly
Просмотров 171Месяц назад
Getting Serial number starting 1 to 1000 instantly
How to get distinct count inside pivot table full video
Просмотров 57Месяц назад
How to get distinct count inside pivot table full video
India Elections 2024 - predicted seat winning by party presented in waffle charts.
Просмотров 307Месяц назад
India Elections 2024 - predicted seat winning by party presented in waffle charts.
Waffle Charts inside Excel to show percentage of completion of a project or task.
Просмотров 157Месяц назад
Waffle Charts inside Excel to show percentage of completion of a project or task.
Dumbbell Chart All the steps inside Excel
Просмотров 182Месяц назад
Dumbbell Chart All the steps inside Excel
How to open same Excel file multiple times and compare the Excel sheets
Просмотров 1582 месяца назад
How to open same Excel file multiple times and compare the Excel sheets
Horizontal Bar chart with Long Labels
Просмотров 2932 месяца назад
Horizontal Bar chart with Long Labels
Unstack with Sequence & Replace command
Просмотров 392 месяца назад
Unstack with Sequence & Replace command
Referencing Intermediate steps from other Power query
Просмотров 3965 месяцев назад
Referencing Intermediate steps from other Power query
Extract Day number of week and assign it to respective column for day of week
Просмотров 258Год назад
Extract Day number of week and assign it to respective column for day of week
Convert Multiple Column Groups to Rows - Power Query Challenge
Просмотров 2,2 тыс.Год назад
Convert Multiple Column Groups to Rows - Power Query Challenge
Butterfly chart in Excel using Data bars from conditional formatting
Просмотров 10 тыс.3 года назад
Butterfly chart in Excel using Data bars from conditional formatting
Hortizontal Stacked Bar chart in Excel - better alternative method
Просмотров 24 тыс.3 года назад
Hortizontal Stacked Bar chart in Excel - better alternative method
How to created multiple line area chart stacked in Excel - advanced excel customised
Просмотров 6573 года назад
How to created multiple line area chart stacked in Excel - advanced excel customised
How to create multiple line chart stacked in Excel - Advanced Excel customised
Просмотров 3,6 тыс.3 года назад
How to create multiple line chart stacked in Excel - Advanced Excel customised
Small multiple stacked column chart in Excel
Просмотров 9783 года назад
Small multiple stacked column chart in Excel
Introduction to small multiple stacked column chart in Excel
Просмотров 4903 года назад
Introduction to small multiple stacked column chart in Excel
Mastering Query Editor in Power BI - Learn in depth about query editor
Просмотров 14 тыс.3 года назад
Mastering Query Editor in Power BI - Learn in depth about query editor
Bullet Charts in Excel with absolute values Multiple flavour
Просмотров 1554 года назад
Bullet Charts in Excel with absolute values Multiple flavour
Bullet Charts in Excel with absolute values - single flavour
Просмотров 4774 года назад
Bullet Charts in Excel with absolute values - single flavour
Bullet Charts in Excel - Multiple Categories
Просмотров 4624 года назад
Bullet Charts in Excel - Multiple Categories
Impressive
👌🏽
Tks
wow
How do you come up with all these awesome tricks which I have not seen even some of the famous channels doing them.
Thanks a lot for appreciation
Genius
Very useful. Thank you.
Superb
excellent
Thanks
Nice. give the files in the description
Thanks Abhay Sir for wonderful Excel trick.Very Useful formula. Keep Sharing
Thanks, please share and subscribe.
Great video…! Really helpful. My sincere gratitude sir!
Sir, Please provide excel files used in your video for practice. Thanks.
Dear sir, It would be of great help to provide / upload data file as well. Regards.
Thanks for the help. Please provide the Data file used. Regards.
How is the performance using this method versus creating an extracted version of the referenced query?
I have not tested that yet.
@@AbhayGadiya thanks. This method is great. I’m hoping someday that there’s a trick that caches the source query to only run once and every dependency can use that cache. Would greatly improve performance.
@@mikehaynes8638 Agree. Seems pretty glaring. The only way I've found that forces the data source to be hit only once is to load the 'intermediate' step to a worksheet, and then use the worksheet as the source for any subsequent queries. But that obviously means you end up with a superfluous worksheet (and it won't be of any use if your dataset contains more than 1m rows).
very informative
thanks, abhay sir keep uploading videos regularly amd share practice file also
thanks, very helpful
thanks abhay sir for this awesome playlist on POWER BI ..
Thank you
thank you Sir.
Highly appreciated for your efforts bringing this concept here Thanks
Saved so much time.. thank you so much sir💐💐
thank you
Hi. Can list until 1m? Maybe list on second column
Pleace sir add subititle transaction i don't understand english well
Would you copy tranform and normalize the data to analyze it in a bi tool or would refactor e.g. ERP software in a way that it is already saving data in a normalized way?
Masha Allah nice sir
Understood👍
Thank you so so much, I've spent like hours to find this problem, I actually found the other but with the code and I have no idea. This one is good and enough for me., thanksss a lot
Glad that it helped you
Which is previous video to create hidden rows
please check the playlist for previous videos
❤
Abhay, you are a great teacher. Thanks for the teachings. I love the breakdown timings.
Thanks
Deeply appreciate your great teaching. Thank you again. From South Korea.
Thanks
Why take long cut? Use indirect in the second data validation list source
Indirect is volatile function
Superb
I explains what 1NF is, but not how to achieve it with Power BI...
How did you do the hidden data?
Could help share the excel file for practice?
Great
Very complicated explanation
Thanks for the video & learn many new things. Need your help to share a video for month-wise forecasted sales versus actual sales for different product families.
you saved me a ton of time! THANK YOU!!!!!
Great Video, thanks for it!!
Product name column doesnt satisfy 1nf
Thank you very much Abhay! Your video helped me save a lot of time analyzing my time series data.
This is so smart!
Great video. How to add one or more bars in the same row? Thanks.
Add more column in your base data