Last seen: Aug 26, 2025
Hi Ronald, I've written a custom function to do this and it uses List.Generate to create a list of the totals of each adjacent 3 months (value...
Hi Tina, Yes it excludes weekends. Our Power Pivot course covers DAX Regards Phil
Hi Bruno, The Facebook connector was retired in 2020. To get data from Facebook you'll need to write your own queries and retrieve data via the ...
Hi Tina, There isn't a native function in PQ to do this but Imke Feldman has written code to calculate this Date.Networkdays function for Power ...
Hi Syed, If the aim is to get the string West Broad Hyundai from the string New Site - West Broad Hyundai on Sheet 2 then just use this formula in ...
Hi Raj, Can you please explain what you mean by dates prior to 1900 are not loading properly. Looking at your file I see a column of dates. But...
Hi Maurizio, If you use Power Query it gets the data without a problem - see attached file. Regards Phil
Hi Clive, Please provide your workbook with query and some sample CSV files. Regards Phil
Hi Miguel, So your problem is resolved? regards Phil
Hi Simon, The use of Table.Buffer isn't very well explained by Microsoft. Sometimes it makes things quicker, sometimes it doesn't. In your case a...
Hi Nathalie, Please supply your workbook with code so that we don't have to recreate everything from scratch. regards Phil
Hi Alan, I would say that I understand that formula because I understand how each of the functions in it works, or at least I understand the parame...
No worries.
OK no worries. Glad to hear you got it figured out