Forum

Build a list in PQ if you don't want to use the table. The final part of the code should be: Cancelaciones={"Cancelacion", "Cancelación Corto ...

Can you provide the sample file?

Hi Mel, Why are you saying that a dropdown is limited to 8 rows? Please prepare a sample file that works with the code, we cannot recreate and t...

You can try the attached file, there are 2 queries. One with a step by step approach to get the result, the other with 1 formula only, but it basicall...

No file attached, please try again. If you can provide the worksheet formulas as well, will be helpful.

No, it's because first is using Text.BeforeDelimiter and the delimiter is at the end of the string, and the second is using AfterDelimiter but the ...

In the second, that is using TextAfterDelimiter, use: Text.AfterDelimiter(_, ReplacementItem,{0, RelativePosition.FromEnd})

Hi Rubas, Took me 20 years to get there 🙂 Mynda recommends this vba course. A good idea is to follow the VBA section of the forum, and try t...

Hi Motar, A Marriage is not simple, you might need an excel priest for this. An inventory system must respect a few rules, like FIFO or LIFO, th...

Can you please provide a sample file with the chart you mentioned?

No, it's not like VBA where you can control other objects. But, you can use VBA to change a query.

Hi Trevor, There are no relationships in Power Query. However, if you load the query results to Data Model, you will be able to create relations...

You also have to review what you are doing with that form data, some values are written in the same place without any sense (to me at least): Cells...

Here is an example of collecting data into an array and transfer to sheet. Note that the transfer is instant if you disable calculation manually be...

If you disable calculation, the transfer to sheet will be almost instant, in less than 1 second. Because you have just a few rows to add, what you hav...