Forum

no worries

Hi Robert, Yes there are a few ways to do this in PQ, check these posts out Easily Compare Multiple Tables in Power Query • My Online Training H...

Hi, When you open a workbook containing macros you should get a default warning towards the top of the screen (under the Ribbon) asking you if you ...

Hi Nelly, Yes, you trap the error and log the filename as you see fit, then continue on with the next file. See these posts for instructions on er...

Hi Scoti, This post describes how to create a stopwatch and is controlled by the value in a cell. Modifying the code should do what you want. T...

Hi, You haven't supplied any data so it's hard to understand what your data looks like. Please, always supply sample data and show your expecte...

Hi Abid, Please, always supply a file so we don't have to recreate your data. You could do this by creating a merged column then filtering out w...

Hi Vicky, You can use List functions rather than merging. You may need to use List.Buffer() to get the best performance. Regards Phil

Hi, Have you read these posts which cover what you need to do Regards Phil

hi Jaryszek, The .. in {1..[Ports]} means include all numbers from 1 to [Ports] Further reading Power Query Lists • My Online Training Hub re...

Hi Ted, Use this URL period1=1595894400&period2=1627430400&interval=1d&filter=history&frequency=1d&includeAdjustedClose=true...

Hi John, If the UPC column is text then I don't know why PQ is complaining that it isn't. Can you supply a file? Regards Phil

No worries.

Hi Tony, You can use List.Intersect to retrieve the make List.Intersect( { Text.Split(Text.Proper([Make and Model])," "), Makes[Make]}){0} B...

Thanks Alan