Skip to content

Instantly share code, notes, and snippets.

@nocodehummel

nocodehummel/power-query-parameter-function.txt

Last active January 8, 2025 08:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save nocodehummel/2f882d8686572f7dc02bd5780c7c7642 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save nocodehummel/2f882d8686572f7dc02bd5780c7c7642 to your computer and use it in GitHub Desktop.
Download ZIP
Power Query Parameter function
Raw
power-query-parameter-function.txt
(Name as text) => let
Parameters = Excel.CurrentWorkbook(){[Name="Parameters"]}[Content],
Param = Table.SelectRows(Parameters, each ([Key] = Name)),
Value =
if Table.IsEmpty(Param) = true then null
else Record.Field(Param{0},"Value")
in Value
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment