Hi Catalin, Thank you for the clarification. Will consider both options and see what works for me.
Hi Mynda, Thanks a ton for your support on this. It really helped me expand my horizons with respect to Power Query. Using the approach that yo...
Hi Mynda, Thanks for the reply. This almost clears the confusion that I have about the Table.Buffer except for one thing - In the post "Where to...
Hi Mynda, Thank you for the reply 1. Since I usually work with files averaging ~5 million rows, I have the Power Pivot enabled. 2. Earlier, e...
Hi Mynda, Thank you for the reply and apologies for creating that confusion. Kindly ignore the jargons (Served, -ve impact, DR% and Sigma level). ...
Hi Catalin, Thank you so much for the reply. - Now, I have an even more clear picture about the background data preview. - With respect ...
Hi Mynda, I have attached an excel sample file with inputs on what exactly I am looking for. Any help would highly be appreciated.
Hi Mynda, Shared below is the M code for one of the many transformations I do in a single excel file. Data source is a shared location on a netw...