Forum

Hi Declan, Can you supply your file? #REF is generated in the Excel sheet, not in PQ or the data Model, so somewhere in a sheet that error is oc...

Hi Jen, I can't find a published limit for the number of steps. But if there was on, I'd imagine it would be in the 100's or 1000's. It'd be be...

Hi Lee, To achieve this you call the RT function again and pass in the Value and Region columns. Just make sure you sort the table by Country firs...

Hi Leonardo, You can add a key to a table using the Table.AddKey() like so Keyed_test_map = Table.AddKey(test_map, {"Function"} , true) Wheth...

Hi Bax, How exactly is the query failing? If you are loading files from a Sharepoint folder and the structure of a file is totally different then ...

Hi David, Please supply a workbook like the one attached, not a table of data that still has to be copied/pasted to create a workbook Regards ...

Hi Wayne, I think what you are after is a Grouped Running Total, I wrote about this here Grouped Running Totals in Power Query • My Online Train...

Hi Andrzej, You can do this by creating a list of the ID numbers ID_List = {1..686} Any number over 686 caused a 404 Not Found error on the ...

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 ...