Forum

Hi Mathias, When merging 2 queries, you need to make sure that the key columns pairs have the same format( numeric, text, date and so on). For exam...

Hi Robert, There is no pattern matching in Power Query yet unfortunately. But you can build your custom pattern matching, like I did in the atta...

Hi Luna, The attached file does not clarify things, brings even more confusion. That's because a table cannot have more than 1 column with the s...

Hi Ken, You can select the rows from a previous step, here is an example: Table.SelectRows(ChangedType, (x)=> [Item] = x[Item] and Date.Month...

You know that you can cancel a query refresh? Right click the query and choose... Cancel.

If type is not specified, it will be considered as type any. You can specify a type if you want, but it should not be text, as the position is an i...

You never sent your file with queries, you just sent the data.

Hi Cedric, Have you tried: let #"Race 1" = (varDate as text, Position) => let Source = Web.Page(Web.Contents("https://entries.horseracingnati...

If your date format in system settings (Control Panel) is set to Australia dd/mm/yyyy, in PQ you just need to change the type of the column to Date, n...

Can you check your system settings? Which is the date format in Control Panel-Regional Settings?

Hi Aye, You can use this formula to count how many unique categories are in the data table for the same ID: =SUM(IF(FREQUENCY(IF([ID]=C2, MATCH(...

Hi, for simple questions like this, you can combine the 2 tables into 1 using Power Query, then create simple pivot tables, like in the file attached....

Hi Aye, I requested a file with your real queries since message no. 16: "You will have to prepare a sample source file you are using, with fake dat...

The function is selecting only the rows from the lookup table where the Diagonal is smaller than the parameter passed to this function: Table.Selec...

Try to optimize the query, that's all you can do. For example, you have this in FilterID function and in MedicareCSV: #"Changed Type" = Tabl...