Finally , a video to satisfactorily end my day The all new excel function made it a lot interesting to move forward but you never fail to give a comparison Thank you so much for the videos
GROUPBY easy winner. However I always use PIVOTBY even when I could get by with GROUPBY. I started that practice after the second time I decided later to add columns to the mix!!
Thank you for showing the several methods for counting. Countifs was easy enough I just wish the criteria syntax did not require the ""& at the = operators because that always gets me. =COUNTIFS(D3:D590,G10:G21,E3:E590,"
Is there any way, power query load data from online drives "folder", without any sign-in. In onedrive, we need to give access to other people to the folder. Couldn't find google drive folder access in power query.
@@excelisfun When we use folder in onedrive from browser link (till layout)..power query consider all files from all folders and creating query with base folders doesn't work for other people even if we give them access to specific folder we are using..do we have method to get data from onedrive folder and share so that other can use when we give them access to the onedrive folder.
I have learned Excel,PBI from your channels and now My level is upgraded...but I have Query maybe you can make a video on that...I have a PBI dashboard and I want to get some data from that visuals maybe in 4 excel files . and I want to put these 4 files in a folder then I have another files which is called a Merge files on which I have merge these 4 files data in 4 different sheet...I don't know what are the methods I can use to do this..maybe PowerAutomate , or directly from excel to import data from that PBI visual.
Hi Mike! How are you? Could I take you on your promise from some time ago? Could I ask for a shout out in some future episode? Also, it does not have to be a table - it can be named range as well :)
Yes, of course. I am still taking care of my Mom's estate after her passing. Until about April, 2024, I am making videos only one time a month. I have a video already recorded that will be out next week. So next time and make videos, I will give a shout out. You should send an email to me at excelisfun at gmail - to remind me that I should do this : )