fill do
1 Topic
Fill Blanks with latest,
Hello Community, please consider helping me out here. I have this dataset of payments registered in the company, wich is imported monthly from xlsx file. A B C D E F G 4 1583181 0 6 28/12/2020 5/1/2021 -0,16 12 1524 4 7 5/1/2021 5/1/2021 1892,05 4 1583181 0 7 5/1/2021 1712 1 225421 0 1 12/1/2021 12/1/2021 672,05 4 1583181 0 8 12/2/2021 12/2/2021 -1711,84 1 225421 0 2 10/2/2021 12/2/2021 672,05 4 1583181 0 9 12/2/2021 1711,84 For each product (each one is a combination [A]-[B]), payments are scheduled in a series of dues, whose secuential number for each product is [D]. Each Due has a foreseen date for payment [E] and an effective paymen date [F], wich may be earlier or later. Some clients may introduce changes to the terms of the service wich are registered secuentially for each product in notes [C]. Lastly, [G] is the amount pactually payed. My issue here is that, as you can see above, some due dates [E] are null in the dataset, and I need to find the way to fill them, for each product (combination [A]-[B]), with the last non-blank date in previous dues [D]. There are nearly 100k records each month, and they are mixed, and usually the date needed for filling is not within the montly batch, so the function "fill down" at PowerQuery is not usefull here. In the above case, it should be 28/12/2020 in the first null and 12/2/2021 in the second empty cell. I don´t have too much experience with this and can´t figure it out how to solve this with PowerQuery or DAX syntax.Solved4.3KViews0likes4Comments