Forum Discussion

anonymous_98's avatar
anonymous_98
Resolver I
4 years ago
Solved

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...
  • amitchandak's avatar
    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
    c

     

    avoid calculation in "in"

  • anonymous_98's avatar
    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
        result

     

     

    we are getting below applied steps for Code2:

     

    1. so what should we do to get the correct applied steps ?
      1. always save your end result in a variable and display that variable in the output.
      2. in our case, we saved the results into the variable result and then displayed the result variable in the output.