Forum Discussion

Ivancito111's avatar
Ivancito111
Resolver I
4 years ago
Solved

Problems with Fill Down in power query

Hello, good afternoon, I wanted to ask about this error that happens to me when I want to fill down, what happens is that I change the value, there is a difference between what is in the power query ...
Data Protection
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Ivancito111 ,

     

    Yes, but select your query, go to Home tab > Advanced Editor then copy everything in there:

     

    Then paste the whole lot into the </> code window here.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Ok. Very difficult to diagnose as-is.

Can you post the M code for your query into a code window (</> button) please?

 

Pete

Ivancito111's avatar
Ivancito111
Resolver I
4 years ago

I am going to publish all the M code, in case there is something I did before that generates the error.

 

-----------------------------------------------------------------

-----------------------------------------------------------------

--------------------------------------------------------------------------

----------------------------------------------------------------------

-------------------------------------------------------------------

-----------------------------------------------------------------------

 

 

These are all the steps I perform with the table

 

I get the data from this website: https://www.sii.cl/valores_y_fechas/dolar/dolar2021.htm

and I use table 12 if you want to try it.

 

Thank you very much for your help

  • BA_Pete's avatar
    BA_Pete
    Super User
    4 years ago

    Hi Ivancito111 ,

     

    Thanks for this, but all you need to do is select your query, then go to Home tab > Advanced Editor and copy all the M code from there and paste into a code window using this button here:

     

    Thanks,

     

    Pete

    • Ivancito111's avatar
      Ivancito111
      Resolver I
      4 years ago
      = Table.FillDown(#"Changed Type1",{"Nov"})

       

      This??

      • BA_Pete's avatar
        BA_Pete
        Super User
        4 years ago

        Ivancito111 ,

         

        Yes, but select your query, go to Home tab > Advanced Editor then copy everything in there:

         

        Then paste the whole lot into the </> code window here.

         

        Pete