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 ,

 

How many rows are in your table?

Some Power Query operations cause the table to re-sort into a different order so, if you have a lot of rows rather than just those visible in your screenshot, this may be the case.

You can check by adding an index column (Add Column Tab > Index Column) at the point where everything looks fine, then check/re-sort your index column later when it looks incorrect. You will quickly be able to see if this is a data issue or merely a sorting issue.

 

Pete

Ivancito111's avatar
Ivancito111
Resolver I
4 years ago

DíaEneFebMarAbrMayJunJulAgoSepOctNovDic

1 734,62719,91721,82 722,11727,76 775,14811,9  
2 731,66721,2  721,52737,79760,2767,1 810,91 
3 734,86726,74 711,06720,44 761,39768,36 814,42 
4710,95730,53731,3 706,29719,93 774,54 803,9815,52 
5702,93737,23729,15717,12705,25 735,06775,54 805,89815,58 
6702,29  717,9703,09 734,66776,69766,53810,63815,58 
7696,18  718,17701,27717,12743,25 770,33816,28815,58 
8709,99736,65733,11714,21 716,06751,36 777,94813,62812,4 
9 735,07738,46708,09 717,82753,67784,5787,51 806,61 
10 733,13733,42 694,47718,98 787,4791,28 806,61 
11713,28728,9728,89 693,74720,77 780,08  806,61 
12718,89722,52718,4711,23700,04 748,7773,01 820,18806,61 
13725,24  709,51707,19 744,1772,78789,91827,56806,61 
14739,72  708,71708,64720,28746,56 784,26820,19806,61 
15735,35724,39718,37707,25 719,17747,93 783,25816,81806,61 
16 718,45721,49701,98 725,11 774,25781,85 806,61 
17 717,38723,47 703,17726,62 784,18  806,61 
18735,06719,78730,93 715,62735,69 789,62 826,19806,61 
19736,11712,14724,59701,55713,63 754,17787,71 820,29806,61 
20733,73  700,96715,31 759,71789,98780,59813,33806,61 
21730,38  697,19  758,85 788,05811,55806,61 
22715,56707,12717,96696,8 746,17755,37 785,1817,61806,61 
23 709,65716,46705,41 749,34750,81786,43785,03 806,61 
24 706,76720,62 716,41735,13 783,3787,24 806,61 
25724,26703,65723,35 727,09731,1 782,17 816,58806,61 
26731,92708,04730,82712,54734,75 758,44783,03 810,16806,61 
27731  707,05732,82 764,21785,06788,98806,55806,61 
28736,88  702,02730,43 761,03 795,48804,32806,61 
29741,4 729,5700,15 732,25767,29 798,63805,47806,61 
30  736,17705,09 735,28758,53784,39803,59 806,61 
31  732,11 724,92  779,97  806,61 

 

This is my table, it does not have more rows or columns, in fact if I do the fill down in the other columns it works correctly, the error appears only with the NOV column.

  • 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

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      4 years ago

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

       

      Ivancito111_0-1636467637375.png

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

      Ivancito111_1-1636467676720.png

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

      Ivancito111_2-1636467701150.png

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

      Ivancito111_3-1636467724560.png

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

      Ivancito111_4-1636467743715.png

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

      Ivancito111_5-1636467766922.pngIvancito111_6-1636467766942.png

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

      Ivancito111_7-1636467784341.png

       

       

      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