Forum Discussion
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 below Applied Steps for the Code1
what is expected number of steps we should get under the Applied Steps TAB?
- we should get 3 steps under the Applied Steps TAB.
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"
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.
2 Replies
- amitchandak
Super User
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"
- anonymous_98
Resolver 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 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.