@@bsmart2gether408 I am good. Been traveling lately. But I make sure not to miss your content. I saw an interesting TH-cam video on how to integrate chatgpt in Excel using power query API by Nick "OpenAI in Excel". And another one from Leila Gharani on how to break the response from chatgpt to different lines.. I think if you combine them it will be a great content.
That's so good that ypu have been travelling. Wow!! Thank you so much for the support. Yes, write office script to connect to ChatGPT and return results. It is an awesome idea. I personally probably won't do it and won't suggest to do it as judgement needed when adopting the code. You never know if the result is correct then you will still need to debug the code. What I suggest to use it at this stage is when we struggle to get thing done and ask chatGPT may inspired you.
@@bsmart2gether408 Yes good suggestion.. I specifically use for DAX..so I am comfortable with power query..But I know very basic DAX..so far has been good. As chatgpt does the debugging part also for me :)
Hi KT thank you again for a wonderful video.Can you share a video on how to handle more 1 million rows in excel as in data model without compromising on performance.
@@bsmart2gether408 Say you need to consolidate 40 sheets into one where row count increases 1 million rows and do the analysis using loading into data model of power query since combined rows are more than 1 million rows combining different sheets take lot of time in power query and loading into data model for analysis. Is there any way to increase the performance of loading data to data model quickly and efficiently?
Remove unnecessary columns, remove redundant data (split the appended table). Completed those by PQ then turn the data model into a star as schema data model.
X is the seed, which is the starting point. th-cam.com/video/CBlqD1vR2bc/w-d-xo.htmlsi=sP9fdz1DzxgoBsUq explained more about the List.Accumulate function.
Great video. Thanks a lot. It would be great if you could provide a cookbook of pq in written form one day ?!:) I would definitely buy it👍
Hi Dennis, Thank you so much for your kind word and support. I should put it down for one of my future goals ☺
Great content again 🙂🙂👍
Thank you, Sumanth. What's up lately?
@@bsmart2gether408 I am good. Been traveling lately. But I make sure not to miss your content. I saw an interesting TH-cam video on how to integrate chatgpt in Excel using power query API by Nick "OpenAI in Excel". And another one from Leila Gharani on how to break the response from chatgpt to different lines.. I think if you combine them it will be a great content.
That's so good that ypu have been travelling. Wow!! Thank you so much for the support. Yes, write office script to connect to ChatGPT and return results. It is an awesome idea. I personally probably won't do it and won't suggest to do it as judgement needed when adopting the code. You never know if the result is correct then you will still need to debug the code. What I suggest to use it at this stage is when we struggle to get thing done and ask chatGPT may inspired you.
@@bsmart2gether408 Yes good suggestion.. I specifically use for DAX..so I am comfortable with power query..But I know very basic DAX..so far has been good. As chatgpt does the debugging part also for me :)
thank you, great work! How about reverse, you have cumulative sum and how to create daily or monthly sales?
Thank you for your compliments. Would you mind explaining a bit more what you mean by reverse with a simple example?
Hi KT thank you again for a wonderful video.Can you share a video on how to handle more 1 million rows in excel as in data model without compromising on performance.
You are very welcome, anand. Would you mind to explain a little more? Running in Power Query? Loading to Excel?
@@bsmart2gether408 Say you need to consolidate 40 sheets into one where row count increases 1 million rows and do the analysis using loading into data model of power query since combined rows are more than 1 million rows combining different sheets take lot of time in power query and loading into data model for analysis. Is there any way to increase the performance of loading data to data model quickly and efficiently?
@@jhaanand81 I would go for Data Model (power pivot) + Power Query combination, actually, it won't work otherwise.
@@mirrrvelll5164 ok thanks will wait for your solution
Remove unnecessary columns, remove redundant data (split the appended table). Completed those by PQ then turn the data model into a star as schema data model.
Hi,
Why in list.acumullate, 2 lists, x & { List.sum...}, IF x is empty...
Obrigado, thanks
Were you referring to the example in the video?
Yes!
X is the seed, which is the starting point. th-cam.com/video/CBlqD1vR2bc/w-d-xo.htmlsi=sP9fdz1DzxgoBsUq explained more about the List.Accumulate function.
@@bsmart2gether408obrigado!
Hi KT no video this Saturday?
Hi Anand, a bit delay this week. Working on it at the moment. Aim to upload it tonight.
@@bsmart2gether408 Thank you so much!!!!
Regarding millions row optimisation, I have to try to cover in other video.
@@bsmart2gether408 Thank you glad you remembered 👍