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

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

    • Ivancito111's avatar
      Ivancito111
      Resolver I
      4 years ago

      I'm going to close the thread because it fixed itself, apparently Power BI was not showing me the correct values, after trying the next day, the 806,6 was loaded in the DB, but it was not showing me.

       

      Thank you very much.