Power Query Custom Column

[jstevens]

Is it possible to create a custom column having a data validation formula?

The formula would reference a different sheet having a list of items to choose from.

[Rudi]

Hi John,

Power query cannot pass a formula to a sheet. You could try to 'jippo' the process by doing the following...

Code: Select all

= Table.AddColumn(#"Removed Columns", "Custom", each "=" & Number.ToText([Quantity]) & "*100")

...but it will end up as a text type in the output column and simply display something like: "=50*100" in the cell. I guess in this instance you could use a macro to convert that string to a calculated output.

Bottom line: Power Query is not a tool to generate Excel based calculations. I'd question if there is not a more efficient and practical way of getting the solution you require.

[jstevens]

Rudi,

I developed other code to create the data validation.

Thanks for responding.

[Rudi]

[hamster]

with Power Query you can try Expression.Evaluate(text)

ee.png