Forum Discussion
anonymous_98
4 years agoResolver I
Not all Power Query Steps are shown under the Applied Steps TAB
Hi All, so here is the scenario. Issue: not all the steps of my power query code are visible in the Applied steps TAB. Code1: let
a = 1,
b = 2
in
a + b we are getting bel...
- 4 years ago
anonymous_98 , I have done a small change and I am able to see all steps
let
a = 1,
b = 2,
c= a+b
in
cavoid calculation in "in"
- 4 years ago
Hey @anonymous_98,
here is the solution to your issue.
Use Below power query code to get the expected correct number of steps under the Applied Steps TAB.
Code2:
let a = 1, b = 2, result = a + b in resultwe are getting below applied steps for Code2:
- so what should we do to get the correct applied steps ?
- always save your end result in a variable and display that variable in the output.
- in our case, we saved the results into the variable result and then displayed the result variable in the output.
anonymous_98
4 years agoResolver I
Hey @anonymous_98,
here is the solution to your issue.
Use Below power query code to get the expected correct number of steps under the Applied Steps TAB.
Code2:
let
a = 1,
b = 2,
result = a + b
in
result
we are getting below applied steps for Code2:
- so what should we do to get the correct applied steps ?
- always save your end result in a variable and display that variable in the output.
- in our case, we saved the results into the variable result and then displayed the result variable in the output.