Skip to content

Instantly share code, notes, and snippets.

@Hugoberry
Last active March 15, 2020 01:17
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Hugoberry/67c6b786a95d23f664918ace51011f67 to your computer and use it in GitHub Desktop.
Save Hugoberry/67c6b786a95d23f664918ace51011f67 to your computer and use it in GitHub Desktop.
Environments in Power Query. What is k?
[x = 1, a = [ x = 2,
b = [ x = 3,
c = [y=1,z=y+x],
z = c[z]],
z = b[z]],
k = a[z]]
[x = 1, a = [ x = 2,
b = [ x = 3,
c = [y=1,z=y+@a[x]],
z = c[z]],
z = b[z]],
k = a[z]]
[x = 1, a = [ x = 2,
b = [ x = 3,
c = [y=1,z=y+Value.Metadata(@a)[x]],
z = c[z]],
z = b[z]] meta [x=x],
k = a[z]]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment