cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ivancito111
Resolver I
Resolver I

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 and the data. I attach photos.

 

Column before fill down: 

 

Ivancito111_0-1636465865232.png

 

Column after fill down:

 

 

Ivancito111_1-1636465937914.png

 

At this point everything is fine, but look how the same column appears later in the data.

 

Ivancito111_2-1636465992127.png

 

Everything is supposed to be 812.4 but it changes to 806.61 with no apparent meaning.

Any information is helpful, thank you very much.

1 ACCEPTED SOLUTION

@Ivancito111 ,

 

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

BA_Pete_0-1636550184319.png

 

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

 

Pete

View solution in original post

9 REPLIES 9
BA_Pete
Super User
Super User

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

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.

Ok. Very difficult to diagnose as-is.

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

 

Pete

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

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

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:

BA_Pete_0-1636468526480.png

 

Thanks,

 

Pete

= Table.FillDown(#"Changed Type1",{"Nov"})

 

This??

@Ivancito111 ,

 

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

BA_Pete_0-1636550184319.png

 

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

 

Pete

View solution in original post

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.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors