Forum

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

Resolved.

Answered on Excel Forum

Answered on Mr Excel

Hi Mohammed, That's a text column so you can't SUM it, hence the Total in the table makes no sense. You can write a measure to calculate total w...

Hi John, You've already mentioned the solution to this which is to record data in the correct, tabular format. As it is, when PQ imports data in...